Migrates PostgreSQL database to MS SQL Server 2000/2005/2008

First of all, if you have not installed ESF Database Migration Toolkit, get it nowdownload. You can using this toolkit to migrate PostgreSQL to MS SQL Server 2000/2005/2008 database in 3 easy steps.

1). In "Choose a Data Source" dialog, choose "PostgreSQL Database";

  • Put the PostgreSQL server name(e.g. localhost) and listenning port(e.g. 5432).
  • Put the PostgreSQL usename(default is "postgres") and its password.
  • Put the source PostgreSQL database name in "Database" box or click "Refresh" button to select a database.
  • Put/select the source PostgreSQL schema name(default is "public").

2). In "Choose a Data Destination" dialog, choose "SQL Server (Standard)" or "SQL Server (Windows Authentication)" ;

  • If you choose "SQL Server (Standard)", then put the SQL Server server name(e.g. localhost), listenning port(e.g. 1433). Or if you choose "SQL Server (Windows Authentication)", you need to put the correctly SQL Server instance name(e.g. localhost\sqlexpress).
  • If you choose "SQL Server (Standard)", put the SQL Server username(default is "sa") and its password.
  • Put the target SQL Server database name, if you forget the database name, press "Refresh" to list them automation.
  • Put/select the target SQL Server schema name(default is "dbo") .

3). In "Select source Tables(s) & View(s)" dialog

  • Select the tables which will be migrated.
  • Click "..." to re-map table structure if you need.

4). In "Execution" Dialog

  • click "Submit" to starting migration.

It is so easy to migrate PostgreSQL database to MS SQL Server, isn't it?.

If you have any questions or suggestions, please contact us. Thank you for your time!