copy all data from SQL Server to Postgres DB

Posted on 2011-03-02
Medium Priority
Last Modified: 2012-05-11
I need to write an upgrade process that will copy all data from SQL Server DB to Postgres DB with the same schema.
I need recommendations how to do that based on :
1) Simpilicity
2 )Reliability
3) Minimize downtime of the system
4) No usage of commercial software (but may use any open source software)

Database can be large

Question by:elimesika
LVL 15

Accepted Solution

Aaron Shilo earned 2000 total points
ID: 35021364
LVL 19

Author Closing Comment

ID: 35021791
Thanks a lot , I have looking for that exactly ....

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question