Transfer Database from PRovidex to SQL Server

• nadellapradeep

  SSC-Addicted

  Points: 446

  More actions

  February 20, 2009 at 9:36 am

  #383988

  Hi Folks,

  Iam New to SQL Server Can anybody help me howto tranfer database Providex to SQL Server. We have database from PRovidex form SAGE MAS 200. i need to transfer database from it to SQL Server. Can any body tell me how to do this task.

  Thanks

  Pradeep Kumar

• jlfalk

  Valued Member

  Points: 71

  More actions

  March 18, 2009 at 3:34 pm

  #962303

  I'm interested in doing the same.

  For right now the only method might be to do the following:

  1. Create a copy of all the tables used within an MS-Access database utilizing the SOTA MAS 90 ODBC driver.

  2. Write queries to update these tables from links.

  3. Save these MS-Access tables and then upload them to MS-SQL.

  I'll look at various MAS forums as well to see if there are any alternatives.