PostgreSQL to MSSQL Tutorial
|[PostgreSQL to SQL Converter] [FAQ] [Download] [Buy]|
|1. Connect to PostgreSQL Server
On this wizard screen connection settings for PostgreSQL server must be specified. The converter can connect to PostgreSQL server using either local or remote mode. The first one is used to connect to the server launched on the same machine where PostgreSQL to SQL Server converter is running. The second mode allows to connect to the server launched on another computer.
By default the program uses local connection mode. It is indicated by radio button "Local". To set up remote connection select "Remote" radio button. Remote connection requires host and port to connect through. Host could be either network name or IP address. Port value is necessary only if it differs from the default PostgreSQL port 5432. Otherwise this field may be kept "as is".
Finally, user name and password are entered.
|2. Connect to
MS SQL Server
This wizard page is designed to enter the necessary settings for connection
to Microsoft SQL Server. "MS SQL Server" field must be filled
with the name of the target SQL Server instance of left empty for local
MS SQL. Also, custom MS SQL port (other than 1433) can be specified in this
field as follows:
|In "SQL Server authentication" mode
PostgreSQL to SQL Server migration tool allows to view database tables owned
by the specified user only. If the user is not the database owner, tables from
"dbo" tablespace are not available. Use "Connect as database
owner" checkbox to bypass this restriction. It will force PostgreSQL to
SQL Server converter to display all tables from "dbo" tablespace.
It is expected that the specified user has enough privileges to read these
tables, otherwise the option will not take effect.
3. Select Databases
On this wizard page source PostgreSQL and destination Microsoft SQL databases must be specified. If you have sufficient permissions to list databases on PostgreSQL server, drop down the combo box to select source PostgreSQL database from the list. Otherwise, type the database name in the field.
Also, log file to write execution traces of the conversion process can be specified on this page. Leave it blank to disable logging.
|4. Conversion Settings
This wizard page is designed to specify PostgreSQL schema (drop down the combo box to select from list or enter it manually) and customize the conversion process using the following settings:
Note: leave schema name blank to convert tables from all schemas. In this case table names will appear in the target MS SQL database in SCHEMA.TABLE format.
|5. Select Tables
This wizard page is designed to manage the list of PostgreSQL tables to convert into SQL Server format.
In the left part of the wizard page there is "Available tables" list box. It contains all available tables of the PostgreSQL database except those that you have been selected already. On the right there is "Selected tables" list box.
To add new PostgreSQL table for migration to MS SQL server select it in "Available tables" list box and click "Add" button (or double-click the highlighted item). Use "Add all" button to add all available PostgreSQL tables.
To remove an item from "Selected tables" list select it and click "Remove" button. Use "Remove all" button to remove all items from "Selected tables" list box.