0

I have table with many data and also I have new structure in other database and system. Is there any program to convert database to new structure?

This program must read structure of both of them and then ask me which field fill which field in new table and also which field drop and etc ...

can any body suggest any application do these things for me?

Also my sql file is MySQL and my structure (new table) is PostgreSQL

BDL
  • 21,052
  • 22
  • 49
  • 55
Mohammad Efazati
  • 4,812
  • 2
  • 35
  • 50
  • SQL Server has SSIS which will do this and doesn't (IIRC) need to involve SQL Server. However I don't think SSIS is available for the express version - you'd need a full SQL Server install. – Rup Apr 11 '11 at 18:55
  • 2
    I suspect you can find something, but depending on the amount of data, I think it might be easier to write it yourself. That way you don't get stuck on the limitations of the tool. If you have lots of data, or limited experience, then maybe this is a bad idea. – MJB Apr 11 '11 at 18:57
  • @MJB at last i find your answer is best answer :(( – Mohammad Efazati Apr 12 '11 at 04:10
  • Sorry to hear that. But I guess that's why we get paid the big bucks, right? – MJB Apr 12 '11 at 16:50

1 Answers1

1

There are several mysql => postgres scripts listed in the postgres wiki, and there's a good guide on syntax changes here

Frank Farmer
  • 38,246
  • 12
  • 71
  • 89