Re: regarding schema only migration from sqlserver to postgres with runmtk.sh - Mailing list pgsql-general

On 06/15/2016 01:30 PM, David G. Johnston wrote:
> On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne
> <maheshpostgres9@gmail.com <mailto:maheshpostgres9@gmail.com>>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.

That is true, but the external PostgreSQL community does:

https://github.com/tds-fdw/tds_fdw

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

If you have access to MS Access, you can create linked tables between
MSSQL and PostgreSQL. You can then create queries to move the data
between the tables. Libreoffice may have similar functionality as well
(I don't know).


Sincerely,

JD


--
Command Prompt, Inc.                  http://the.postgres.company/
                         +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.