How can I migrate from Progress database to SQL server 2008 r2 databse

• elmozamil

  SSC Veteran

  Points: 274

  More actions

  January 2, 2012 at 4:36 am

  #265710

  Hi,

  Can anybody help me on migration of Progress database to SQL server 2008 r2 or any version.

  Thanks in advance

  Elmozamil Elamir

  MyBlog

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  January 2, 2012 at 5:41 am

  #1427406

  What version of Progress ?

  Have you got the relevant Progress ODBC driver for your version?

  Are you just looking at extracting the data from Progress...or sometning else?

  How many tables/size/rowcounts etc.

  Generally speaking, getting the data out is relatively easy.....how you then interpret it will be based on how well you know the Progress db.....do you have any schema/documentation on the Progress db?

  ________________________________________________________________
  you can lead a user to data....but you cannot make them think
  and remember....every day is a school day

• elmozamil

  SSC Veteran

  Points: 274

  More actions

  January 2, 2012 at 6:54 am

  #1427419

  previously I used Import/Export wizard, I found ODBC driver and the import/export wizard work fine but the problem for each table I must do it.

  The solution that I am trying to find is how could I specify the database and then all my data in database tables copied to SQL Server, if it possible the definition of tables copied with it.

  Thanks for you quick response.

  Elmozamil Elamir

  MyBlog

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  January 2, 2012 at 7:28 am

  #1427425

  elmozamil (1/2/2012)

  ---

  previously I used Import/Export wizard, I found ODBC driver and the import/export wizard work fine but the problem for each table I must do it.

  The solution that I am trying to find is how could I specify the database and then all my data in database tables copied to SQL Server, if it possible the definition of tables copied with it.

  Thanks for you quick response.

  Elmozamil Elamir

  MyBlog

  One Export / Import run should cover all the tables. It will not be one run per table. SQL Server Export Import Wizard behaves like this only for Excel / Txt files.