Search Postgresql Archives

Re: regarding schema only migration from sqlserver to postgres with runmtk.sh

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne <maheshpostgres9@xxxxxxxxx> wrote:
may i know  recommended approach to migrate the tables from sql server to postgresql instead of using 3rd party tools


​Answering this specifically.

There are none.  The community PostgreSQL project maintains no tools that speak to SQL Server.

One possible option to use the PostgreSQL's FDW capabilities with a suitable third-party extension that does talk to SQL Server.

The other is to dump plain SQL, hopefully standard-conforming, INSERT statements from the SQL Server and load them into PostgreSQL via psql.

I suppose SQL Server has some means to export in TSV/CSV or other row-oriented structured output.  The \copy psql meta-command or COPY SQL ​command could load that data.


Depending on the table structures having SQL Server dump the DDL (i.e., CREATE TABLE) for the tables and loading them via psql might be possible as well.

​One area that the commercial space ​helps fulfill is inter-vendor inter-operability tools.  While this is a boon to the PostgreSQL community as matter of practicality support for those tools.  Before using said tools you should ensure that you can reliably connect, using the standard tools, to the databases in question and perform general actions thereon.  Failures there should be resolved first and the communities can help you with that.

David J.




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux