Ispirer Migration Knowledge Base

User Tools

Site Tools

You are here: Ispirer Migration Knowledge Base » Ispirer Migration Knowledge Base » User's Guide » How To Migrate Microsoft SQL Server to PostgreSQL Using Ispirer MnMTK ToolKit

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
sqlways:users-guide:migrate-mssql-to-postgres [March 29, 2019, 11:08:33 AM] – [Converting a Whole Folder] darya.prikhodkinasqlways:users-guide:migrate-mssql-to-postgres [May 31, 2023, 05:28:12 PM] (current) – external edit 127.0.0.1
Line 1: Line 1:
 \\ \\
-__**[[http://www.ispirer.com|Ispirer Home Page]] +[[https://www.ispirer.com|Ispirer Website]] 
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] +[[https://www.ispirer.com/products/migration-toolkit|Ispirer Toolkit Overview]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]**__+[[https://www.ispirer.com/download/download-demo|Free Trial]]
 \\ \\
  
Line 9: Line 9:
 You can use Ispirer Migration and Modernization Toolkit to migrate Microsoft SQL Server Database (Tables, Data, Views, Stored Procedures, Functions, Triggers, User Defined Types, Sequences, Indexes, Constraints, Synonyms.) to PostgreSQL. This toolkit includes 3 tools: You can use Ispirer Migration and Modernization Toolkit to migrate Microsoft SQL Server Database (Tables, Data, Views, Stored Procedures, Functions, Triggers, User Defined Types, Sequences, Indexes, Constraints, Synonyms.) to PostgreSQL. This toolkit includes 3 tools:
  
-   * **SQLWays Wizard**  -  Tool that is able to migrate the objects directly from one database to another (Tables, Data, Views, Stored Procedures, Functions, Triggers, User Defined Types, Sequences, etc.). To connect to the source database it uses ODBC connection and to load the converted objects it uses __**[[http://wiki.ispirer.com/sqlways/faq/utilities-to-make-import|native utilities]]**__.+   * **SQLWays Wizard**  -  Tool that is able to migrate the objects directly from one database to another (Tables, Data, Views, Stored Procedures, Functions, Triggers, User Defined Types, Sequences, etc.). To connect to the source database it uses ODBC connection and to load the converted objects it uses __**[[https://wiki.ispirer.com/sqlways/faq/utilities-to-make-import|native utilities]]**__.
    * **Ispirer Migration Studio**  -  Tool which is able to convert only one script at a time. In this script you can provide sql statements and definitions of the following objects:Tables, Views, Stored Procedures, Functions, Triggers, User Defined Types, Sequences, etc.    * **Ispirer Migration Studio**  -  Tool which is able to convert only one script at a time. In this script you can provide sql statements and definitions of the following objects:Tables, Views, Stored Procedures, Functions, Triggers, User Defined Types, Sequences, etc.
    * **Ispirer Migration Commander**  -  Tool which is able to convert multiple scripts or all the scripts in the provided folder including all the sub-directories. In these scripts you can provide sql statements and definitions of the following objects:Tables, Views, Stored Procedures, Functions, Triggers, User Defined Types, Sequences, etc.    * **Ispirer Migration Commander**  -  Tool which is able to convert multiple scripts or all the scripts in the provided folder including all the sub-directories. In these scripts you can provide sql statements and definitions of the following objects:Tables, Views, Stored Procedures, Functions, Triggers, User Defined Types, Sequences, etc.
Line 34: Line 34:
  
 If you run one of the tools for the first time, you need to register the toolkit using the license information you should have received. Here you can find a step by step guide that describes how to register Ispirer Migration and Modernization toolkit: If you run one of the tools for the first time, you need to register the toolkit using the license information you should have received. Here you can find a step by step guide that describes how to register Ispirer Migration and Modernization toolkit:
-__**[[http://wiki.ispirer.com/sqlways/faq/how-to-register| How to Register Ispirer Migration and Modernization Toolkit]]**__+__**[[https://wiki.ispirer.com/sqlways/faq/how-to-register| How to Register Ispirer Migration and Modernization Toolkit]]**__
  
  
Line 59: Line 59:
 {{:sqlways:users-guide:ms_sql_odbc.png|}} {{:sqlways:users-guide:ms_sql_odbc.png|}}
  
-**__Please note:__** Our tool works using the ODBC connection to the source database only! It means that before using SQLWays Wizard tool you need to install the ODBC driver and tune the ODBC connection to the database that should be migrated. Some additional information about the ODBC driver installation and configuration can be found here: **__[[http://wiki.ispirer.com/sqlways/users-guide/setting-up-database-connection/sql-server|Setting Up Microsoft SQL Database Connection]]__**+**__Please note:__** Our tool works using the ODBC connection to the source database only! It means that before using SQLWays Wizard tool you need to install the ODBC driver and tune the ODBC connection to the database that should be migrated. Some additional information about the ODBC driver installation and configuration can be found here: **__[[https://wiki.ispirer.com/sqlways/users-guide/setting-up-database-connection/sql-server|Setting Up Microsoft SQL Database Connection]]__**
  
-**__Please note:__** User that we specify on this page should have appropriate rights to make selects from system tables from your source database. More information about source database user privileges can be found here: **__[[http://wiki.ispirer.com/sqlways/users-guide/check-list/setting-up-source-user-privileges#microsoft_sql_server| Source User Privileges]]__**+**__Please note:__** User that we specify on this page should have appropriate rights to make selects from system tables from your source database. More information about source database user privileges can be found here: **__[[https://wiki.ispirer.com/sqlways/users-guide/check-list/setting-up-source-user-privileges#microsoft_sql_server| Source User Privileges]]__**
  
  
Line 70: Line 70:
  
 This information will be used by our tool to generate correct command lines to psql.exe native utility of the target database. This information will be used by our tool to generate correct command lines to psql.exe native utility of the target database.
-More information about the utilities used for making import is stored here: __**[[http://wiki.ispirer.com/sqlways/faq/utilities-to-make-import#postgresql|PostgreSQL Native Utility]]**__+More information about the utilities used for making import is stored here: __**[[https://wiki.ispirer.com/sqlways/faq/utilities-to-make-import#postgresql|PostgreSQL Native Utility]]**__
  
 The next step is to specify objects for conversion from the list of objects that our tool was able to extract from MSSQL database. To select objects you can just drag-n-drop the required objects to the right pane of the tool. Or you can select objects using buttons at the bottom of the tool: The next step is to specify objects for conversion from the list of objects that our tool was able to extract from MSSQL database. To select objects you can just drag-n-drop the required objects to the right pane of the tool. Or you can select objects using buttons at the bottom of the tool:
Line 96: Line 96:
 For more information about the PostgreSQL native utility, that will be used by our tool, please refer to: For more information about the PostgreSQL native utility, that will be used by our tool, please refer to:
  
-**__[[http://wiki.ispirer.com/sqlways/faq/utilities-to-make-import#postgresql|PostgreSQL Native Utility]]__**+**__[[https://wiki.ispirer.com/sqlways/faq/utilities-to-make-import#postgresql|PostgreSQL Native Utility]]__**
  
  
Line 146: Line 146:
 {{:sqlways:users-guide:ms2pg_comm_folder.png|}} {{:sqlways:users-guide:ms2pg_comm_folder.png|}}
  
-Then you have to provide the target directory, where converted files will be placed. Also when migrating from MS SQL Server to PostgreSQL we can provide a "File Mask" to convert only the files with the required extension. If we need to convert all the files, we need to leave the file mask as is. Then click "Ok". Please see the screenshot:+Then you have to provide the target directory, where converted files will be placed. Also when [[https://www.ispirer.com/products/sql-server-to-postgresql-migration|migrating from MS SQL Server to PostgreSQL]] we can provide a "File Mask" to convert only the files with the required extension. If we need to convert all the files, we need to leave the file mask as is. Then click "Ok". Please see the screenshot:
  
 {{:sqlways:users-guide:ms2pg_comm_res.png|}} {{:sqlways:users-guide:ms2pg_comm_res.png|}}
Line 168: Line 168:
  
 If you have any questions or face any issues, please feel free to mail us: __**[[[email protected]]]**__ If you have any questions or face any issues, please feel free to mail us: __**[[[email protected]]]**__
- 
- 
-\\ 
-__**[[http://www.ispirer.com|Ispirer Home Page]]**__ 
-__**[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]]**__ 
-__**[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]**__ 
-\\ 
© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.