On 06/15/2016 01:30 PM, David G. Johnston wrote:
On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne <maheshpostgres9@xxxxxxxxx <mailto: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.
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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
