Advantage to Vision conversion success

The database has been successfully converted from an Advantage format to a Vision format. Key point! If you try to specify a target database name (in the conversion utility) that already exists on the sql server, you will run into a failed conversion. We needed to specify a Vision database name that did not exist on the SQL server.

Advantage to Vision Conversion

Both our Advantage version as well as SQL version were out dated, so we are using a process of upgrading as well as conversion which has involved the following steps. These are based on several conversations that have taken place with Deltek support and consulting.

Original configuration was Advantage V8.0e being hosted on a SQL7 database. The final conversion needs to be done on the SQL 2008 platform so we need to do an intermediate upgrade to SQL2005. Why? Because you cannot upgrade directly from SQL7 to SQL2008. So the process will be SQL7 --> SQL2005 --> SQL2008.

• Convert DB from 8-9.0 using the Deltek conversion utility
• Convert DB from 9.0 - 9.1 using the Deltek conversion utility
• Backup DB on SQL 7
• Restore 9.1 DB .bak file to SQL2005 server.
• Change Compatability level to 90 (SQL2005)
• Run DBCC Update usage query
• Backup DB
• Restore DB on SQL2008 server
• Change compatibility level to 100 (SQL2008)
• Run DBCC Update usage query
• Backup DB
• Advantage DB is now on our new W2K8 server running SQL 2008.
• Install Advantage on W2K8 server
• configure/verify advlink.mdb through Advantage
• Install Advantage to Vision 6.1 conversion utility
• Run Adv to Vis conversion utility

The result of the conversion was some errors. So now we will utilize Deltek technical support to help resolve the issues.