?
Solved

copy all data from SQL Server to Postgres DB

Posted on 2011-03-02
2
Medium Priority
?
504 Views
Last Modified: 2012-05-11
HI
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

Thanks
0
Comment
Question by:elimesika
2 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 2000 total points
ID: 35021364
0
 
LVL 19

Author Closing Comment

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

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

862 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