What happens is that I have a PostgreSQL script and I need to pass it to SQL Server. Does anyone know a tool that is effective?
What happens is that I have a PostgreSQL script and I need to pass it to SQL Server. Does anyone know a tool that is effective?
Do you have a Script or database DB (Data and Schema) ???.
Whatever the case may be, there are two options: 1 - The "Free", but more work. 2 - The simple and easy but expensive $$.
1 -For the first option is not difficult just that it costs more work to do it. Now if you have the correct drivers in your MS-SQLServer for Postgrest support (ODBC) you can do an export / import data via wizard to copy the information. If your script is very large at the data level you may find some incongruities for having a large number of rows, so you would have to move to simple segmented inserts.
2 - There are payment tools that export you your full Schema (table data, indexes, foreign keys, constraints but without data) Full Export Scheme Export , but once you have your DB defined it is just a matter of doing a simple txt import of the data.