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