Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
sqlways:users-guide:migrate-mssql-to-postgres [November 09, 2018, 02:23:30 PM] – alexandr.kirpichny | sqlways: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:// | + | [[https:// |
- | [[http:// | + | [[https:// |
- | [[http:// | + | [[https:// |
\\ | \\ | ||
====== How To Migrate Microsoft SQL Server to PostgreSQL Using Ispirer MnMTK ToolKit ====== | ====== How To Migrate Microsoft SQL Server to PostgreSQL Using Ispirer MnMTK ToolKit ====== | ||
- | To migrate Microsoft SQL Server Database to PostgreSQL | + | You can use Ispirer Migration and Modernization Toolkit to migrate Microsoft SQL Server Database |
- | * **SQLWays Wizard** | + | * **SQLWays Wizard** |
- | * **Ispirer Migration Studio** | + | * **Ispirer Migration Studio** |
- | * **Ispirer Migration Commander** | + | * **Ispirer Migration Commander** |
- | So after the installation of Ispirer Migration and Modernization ToolKit you will 3 tools on your desktop: | + | After the installation of Ispirer Migration and Modernization ToolKit you will see 3 tools on your desktop: |
- | {{: | + | {{: |
+ | \\ \\ \\ \\ | ||
+ | {{: | ||
\\ \\ \\ \\ | \\ \\ \\ \\ | ||
- | {{: | ||
+ | {{: | ||
+ | \\ \\ \\ \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | //**Ispirer Notification: | ||
+ | |||
+ | You can get Ispirer Migration and Modernization Toolkit for free by filling out the form on our official web site: | ||
===== 1. Registration ===== | ===== 1. Registration ===== | ||
- | If you run one of the tools for the first time, you need to register the tool using the license information | + | If you run one of the tools for the first time, you need to register the toolkit |
+ | __**[[https:// | ||
- | ==== 1.1 Registration in SLQWays Wizard ==== | ||
- | In the SQLWays Wizard tool, on the " | + | __**Ispirer Notification: |
- | {{:sqlways:faq: | + | If you don't have a license, you can get it by filling out the form on our official web site: __**[[https://www.ispirer.com/ |
- | After that we need to find the file with the license and open it. | + | ===== 2. Conversion ===== |
- | {{: | + | After the registration process is done, and toolkit is successfully registered, we can proceed with the conversion of Microsoft SQL Server Database into PostgreSQL. |
- | Then registration name and registration number should appear in appropriate windows and you will need to click " | ||
- | {{: | + | ==== 2.1 Conversion Using SQLWays Wizard ==== |
- | If everything was correct you will see the updated information about the limitations of your current license on the " | + | To convert |
- | ==== 1.2 Registration in Studio or Commander ==== | + | On the first page of SQLWays Wizard we need to provide the project directory. In this directory our tool will generate project file that will store information about the current migration process. |
- | To do that in Studio or Commander tool and click " | + | {{:sqlways: |
- | {{: | ||
- | In the opened window please click "Enter License" | + | Then we need to choose |
- | {{: | + | {{: |
- | In the opened window you will have to provide registration name and registration number. Or you can click "Read From File" button and select | + | **__Please note:__** Our tool works using the ODBC connection |
- | {{:sqlways: | + | **__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:// |
- | If everything was correct you will see the " | ||
- | \\ | ||
- | **__Please note:__** you can get the demo license | + | On the next page we need to select target database from the list of the supported databases. And then to specify correct information about the target database, for example, server name, database name, user name and a password. |
- | ===== 2. Conversion ===== | + | {{: |
- | After the registration process is dome, and toolkit registered successfully, | + | This information will be used by our tool to generate correct command lines to psql.exe native utility |
+ | More information about the utilities used for making import is stored here: __**[[https:// | ||
+ | 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: | ||
+ | {{: | ||
+ | If during the migration process the list of objects was updated, for example some additional objects were created or dropped from the database, you can refresh the list of extracted objects. To do that just right click on the required object type or " | ||
+ | {{: | ||
- | ==== 2.1 Setting Required | + | If required, you can specify different options that can be used to customize the conversion process. These options can be found on the " |
- | == 2.1.1 Direction Options == | + | {{: |
- | First of all in both tools we need to provide | + | After that you will need to specify |
- | {{:sqlways:users-guide:source_trg.png|}} | + | {{:sqlways:faq:exp_dir.png|}} |
- | == 2.1.2 Options In The Options File == | ||
- | After that if required | + | Then we need to specify |
- | + | ||
- | **c: | + | |
- | {{: | + | {{: |
- | If you want to copy the options file, and use it from another location, then you heed to provide a path to the required options file. You can do that in the Studio or Commander by clicking " | + | For more information about the PostgreSQL native utility, that will be used by our tool, please refer to: |
- | {{:sqlways:users-guide: | + | **__[[https:// |
- | And in the opened window, in the option "INI File Path" provide a correct path to the required options file, like it is done on the screenshot: | ||
- | {{:sqlways: | + | After all these steps we need to run the migration. Migration process itself includes two steps: " |
- | \\ | + | |
- | More information about the sqlways.ini file and supported options can be found here: [[http:// | + | To run the conversion process, we need to click "Start Conversion" |
+ | {{: | ||
- | ==== 2.2 Running The Conversion ==== | + | After the conversion process is finished, we need to run the import process. So we need to go to the " |
- | After setting all the required options we need to specify the source code that need to be converted. | + | {{: |
- | === 2.2.1 Conversion Using Ispirer Migration Studio === | ||
- | In the Studio tool we need to provide | + | After the migration process you can review all the generated files in the export directory by clicking |
- | {{: | + | ==== 2.2 Scripts Conversion Using Ispirer Migration Studio and Ispirer Migration Commander ==== |
- | After the conversion | + | If you need to convert Microsoft SQL Server |
+ | === Conversion Using Ispirer Migration Studio === | ||
- | === 2.2.2 Conversion | + | First we need to specify the source and target. This can be done using the " |
- | == 2.2.2.1 Converting Files == | + | {{: |
- | In the Migration Commander we need to specify | + | After the conversion you can review |
- | {{: | + | === Conversion Using Ispirer Migration Commander === |
- | In the opened window you need to provide the target directory, where our tool will put the converted files and click " | + | == Converting Files == |
- | {{: | + | In Ispirer Migration Commander we need to specify the source and target. This can be done using the " |
- | After the conversion process is finished, the converted files will be located in the target directory. And by clicking the files in the left and right panels, you can compare source code and generated target. | + | {{: |
- | {{: | + | In the opened window you need to provide the target directory, where our tool will put the converted files. After that please click " |
- | \\ | + | |
+ | {{: | ||
+ | |||
+ | After the conversion process is finished, the converted files will be located in the target directory. And by clicking the files in the left and right panels, you can compare the source code and generated target code. | ||
\\ | \\ | ||
- | == 2.2.2.2 | + | == Converting |
- | Also in the Ispirer Migration Commander tool you can specify a whole folder for a conversion. And in that case the tool will convert all the files in the folder and its subfolders. | + | In Ispirer Migration Commander tool you can also specify a whole folder for conversion, so that the tool will convert all the files in the folder and its subfolders. |
- | In that case you just need to choose the selected folder and click "Run Conversion" | + | In order to do that you just need to choose the selected folder and click "Run Conversion" |
- | {{: | + | {{: |
- | Then you have to provide the target directory, where converted files will be placed. Also when migrating from MS SQL Server to PostgreSQL we need to provide a "File Mask" to convert only the files with the extension | + | Then you have to provide the target directory, where converted files will be placed. Also when [[https:// |
- | {{: | + | {{: |
- | After the conversion process is finished, the converted files will be located in the target directory. And by clicking the files in the left and right panels, you can compare source code and generated target. | + | After the conversion process is finished, the converted files will be located in the target directory. And by clicking the files in the left and right panels, you can compare |
- | {{: | ||
\\ | \\ | ||
Line 150: | Line 158: | ||
\\ | \\ | ||
- | Also you can review the recorded demo on our youtube channel that shows how to migrate Microsoft SQL Server Database to PostgreSQL code: [[https:// | + | Also you can review the recorded demo on our youtube channel that shows how to migrate Microsoft SQL Server Database to PostgreSQL code: __**[[https:// |
\\ | \\ | ||
- | If you will have questions or face with some difficulties please feel free to mail us: [[support@ispirer.com]] | + | You can download Ispirer Migration and Modernization toolkit and get the demo license from our official web site just filling out the form on this page:__**[[https:// |
\\ | \\ | ||
- | [[http:// | + | |
- | [[http:// | + | |
- | [[http://www.ispirer.com/? | + | If you have any questions or face any issues, please feel free to mail us: __**[[support@ispirer.com]]**__ |
- | \\ | + |