Full Convert Basic Conversion

Tutorial showing how to do a straightforward database conversion from SQL Server to PostgreSQL using Full Convert.

---

Closed Caption:

hi I'm going to do basic conversion
using full Convert
going to convert sequel Server database
to post Chris database
to start let's click on the new database
conversion button
this opens conversion project wizard
on the left side I can see the list of
all supported databases
didn't know which source database I half
and only have a database file which I
want to migrate to another database
format
I could click on the recognize my
database file button
full Convert would analyze my file and
tell me what it is
he would even selected as a source
database for me so I can convert it
right away
ever as I said for this demo I will be
converting a sequel Server database to
pose kress
some going to click on sequel server now
I will fill our connection information
servername username and password
let me select a source database from
that server I will choose
AdventureWorks database
a soft demo database
by clicking Next I
to target database page
a post-crescent stalled on my local
machine some selecting
and typing incorrect password
I database that doesn't yet exist and
four convert all created for me
asks me to confirm to make sure I didn't
mistype the database name
I will confirm and move on to third step
we r presented with a list of all the
tables present in the source equal
Server database
just to recap first up was selecting
source database
second was selecting target database and
third step now is selecting which tables
we want to copy from Siebel Server to
post dress
I'll
here's the summary page
want to convert
base immediately some clicking the
Convert button then conversion will
start right away
as you can see focus
is very fast
already created all the tables so all
the tables from sequel Server database
are already present in the post Chris
database which shows as a target
it is now copying all the data from all
the tables
please note that full Convert is copying
data in chunks
this means that even if your table has
hundreds of millions of records
it will copy it very efficiently without
consuming a lot of memory
and without straining your database
servers
above you can see total Prague
Respir for all the tables and in the
center is the progress bar for table
currently copied
speed for current table is fifteen
thousand records per second
course depends on the structure the
table and databases you are using
copying the data
full Convert
the indexes in foreign keys so the
postrace database will have exactly the
same indexes
and foreign keys says our source equal
Server database
Postgres is a fast database so this
finish is very quickly
I'll conversion is complete
now our post crest database contains all
the tables from our source equal server
with all their data indexes and foreign
keys
reports that it successfully migrated 86
tables with 761 thousand records in
total
sure everything is properly converted I
will click the Browse target database
Biden
as we have a built-in target database
explore don't need external post Chris
database management application at all
0 click the count rose button to see
that target tables have data
and go through my post crest database
let's see what is the address table look
like
enough all the date is here
I can click on the best fit button to
have
integrate optimally resized
we will also look at address to
able and we can do the same for any
other table in our progress database
thank you very much hope it was clear
how easy full Convert is to use
if you have any questions don't hesitate
to send an email to support at spectral
cord %ah com
will be glad to help you out