Full Convert Tutorial •
PostgreSQL to SQL Server migration
Full Convert Enterprise quickly copies PostgreSQL database to SQL Server.
Source database is known as PostgreSQL, Postgres, PG
Target database is known as SQL Server, MS SQL Server, MSSQL Server, Microsoft SQL Server, SQL, MSSQL (related files: mdf, ldf, bak).First look at Full Convert
The conversion of PostgreSQL to SQL Server migration using Full Convert is simple and has to do a few quick steps:
- Connect to your source target databases
- Optional: Choose which tables you want to convert (all are selected by default)
- Start the conversion, sit back and enjoy
- Optional: Explore your new data in the target database using a built-in database explorer
When we start Full Convert, you will notice a welcome panel with links for common tasks. Let"s start a new conversion.
Click the Create new conversion link or click the New button in the ribbon above.
Connection to source PostgreSQL database
Initial screen shows you that Full Convert will automatically detect your database if you don"t know which one do you have. Of course, if you do know your database, do select it from the list on the left.
We will choose PostgreSQL from the list of available source database engines. Connecting to Postgres is straightforward - we need to specify server name/IP, username, password and database name.
Connection to target SQL Server database
List on the left shows all the databases which can be filled with your source database data. Select the one you need and fill-in required parameters.
We will choose SQL Server from the list of available source database engines. Depending on your SQL Server setup, you will need to connect using Windows or SQL Server authentication.
Depending on your SQL Server installation, we need to specify the server name, or server\instance name in the Server field.
Table selection
We will select all source tables for conversion by default. In case you only need some tables, simply deselect the ones you don"t need - or deselect all, then select just the tables you do need.
Review
Here you can see how many tables will be converted. To start conversion right away, click on the Convert! button. To show contents of target database without converting, click on the Explore button. Use that to inspect target database prior to conversion, or to save the conversion project for later before even converting the first time.
Click the Convert! button to get started.
Conversion progress
Conversion is highly-optimized to run as fast as possible, yet provides top-notch reliability. Huge tables are converted in small chunks at a time, preserving memory and ensuring that your computer stays fast and responsive.
- Running your custom pre-conversion SQL scripts, if any
- Creating all selected tables in your target database
- Copying data
- Applying indexes
- Applying foreign key constraints
- Running your custom post-conversion SQL scripts, if any
PostgreSQL to SQL Server conversion summary
Here you will see basic conversion statistics, such as number of tables and records copied to target database.
If there were any warnings or errors during conversion, you will be able to examine them in detail.
Finally, complete SQL log is available for you if you need it. This feature can be enabled in project options screen.
Conclusion
This small tutorial shows how easy it is to convert PostgreSQL to SQL Server using Full Convert Enterprise.
If you like what you see, please purchase Full Convert at our site. Delivery is instant via email, and with 60 day money-back guarantee there is no risk in purchasing.
Also, if you want to make sure our applications fits your needs before buying, you can download free trial version.
60 Day Money-back Guarantee • Instant Delivery
- A single seat license
- Install on up to 3 computers
- ~ 40 databases supported
- ODBC drivers supported
- Console application included
- Built-in recurring conversion scheduler
- Support by developers who made this
- 60 day money-back guarantee
- Instant delivery
- License for everyone at the office
- Everything in Full Convert Enterprise + Unlimited users on the single location + Priority support + Easy online license management
Customer care
Log into our website with email used to purchase to access your licenses and invoices, as well as manage activated computers. Support and upgrades are available with active maintenance.
Standard license
Your license to use your purchased software is perpetual - it will never expire. One year of maintenance is included in price and you can install our product on up to 3 computers.
Subscription
You are charged every month (monthly subscription) or every year (yearly subscription).
You get access to our 4 desktop products - Full Convert, Replicator, Query and Documenter. Each of these applications can be installed on up to 5 computers.
As long as subscription is active, maintenance is active. Licenses are disabled when subscription is canceled.
Maintenance explained
Maintenance covers technical support and access to upgrades of the application. As long as your maintenance is active, you can log into our website and download the latest release.
Maintenance can be automatically extended via maintenance subscription.
If you opt to manually handle maintenance, you can extend it before it expires or renew it up to 12 months after it expires. Extension is cheaper than renewal and therefore recommended.
Subscriptions don't need maintenance extensions, as all subscribers have active maintenance for as long as they are subscribed.
Resellers
Resellers should contact us to obtain a discount.
Working across companies
Each license is to be used in a single company, but there are two possible exceptions:
-
Consultant working with clients
A single person can work with databases of several client companies, but one license can be used for 3 clients at most.
-
A company wants to bundle our application with its own application
A Worldwide license must be purchased. Please contact us for details.
