FormerMember

MAS 90 Providex to SQL Conversion / Archive Reporting purposes

Posted By FormerMember

Hello, I am completely new to this. I am a SQL DBA and I have been asked to take our OLD MAS90 system convert the data to SQL and write reports to allow accounting people to find data from our old system.  We currently use MS Dynamics NAV.     We switched a few years ago.  The old server for MAS 90 we want to retire.  

I am looking for some sort of utility method of converting or scripts or something.  SQL querying tables in ODBC does not appear to be working, but that could be me not knowing what I am doing.   Using the reports and EXPORT ability to export to CSV Works but no column names.   Exporting via ODBC to a SQL Server creates a table but inserts zero rows.  

Any help, pointing to either utilities currently still available or heck consulting services that could do the whole thing might even be on the table.   I'm grasping at straws at this point.  

Thanks.

Will

  • 0

    I am assuming you are using a pre-2014 version (with mention of MAS90) so 64-bit ODBC is not an option.  Spin up a 32-bit version of SQL, and set up a linked server to the MAS90 database (one company code at a time).  The instructions are posted somewhere if you look.  Then you can do select * from openquery... to pull the data into SQL one table at a time.

    VBScript ODBC queries also work, but those take longer to run... all depends on what methods you are comfortable with.