Solved

copy all data from SQL Server to Postgres DB

Posted on 2011-03-02
2
493 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

734 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