How to convert existing Sql server database to postgre database?

How to convert existing Sql server database to postgre database?
Yogendra SahuSoftware DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nociSoftware EngineerCommented:
1) get a description of all current tables
2) determine the order in which tables need to be processes; First all tables that don't refer to other tables,
   Then tables that refer to already existing tables from previous step
     and repeat this until all tables are specified.
3) create the data description for each of the tables for the Postgresql database (and take a note which conversions need to be done);
4) create a script that connectes to both databases and copies all data (in the table order determined in step 2) with the conversion rules determined in step 3
5) test the script built in step 4 on a separate database copy, if there are errors recheck/redo step 3 & step 4.  
6) convert the production database to production postgresql, in case of errors what went differently wrong compared to step 5, redo step 3-5.....

(use a copy of production data to not block any transaction there).
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.