We have a SQL server that need to be decommissioned and now have a new server running that we want to copy or migrate databases. Is there documentation on switching SQL servers (both 2005) and migrating AutoPLANT databases? Also, is there information on upgrading from SQL2005 to SQL2008?
Thanks,
Mark Christenson
Mark,
I guess that you have not called the new server the same as the old server ... which would have resolved this ... (although you would still have had to migrate your databases)
However, I often switch between my two machines here and only have to point my project.ini file to the new server (I keep the instances name the same)
I recently moved from 2005 to 2008 and AutoPLANT was none the wiser it was very straightforward. Although I cannot reattach my 2008 database to any 2005 instances, I can toggle between the two servers.
So depending upon how many projects you want to upgrade you will need to point your PROJECT.INI to the new server. If you are using ProjectWise, this becomes much simpler as you only need to edit the one table and could do a search and replace.
Glen
A lot of times it will just be easier to open the Project.ini in Notepad as Glen said. However, you can also do this through the Project Administrator and test the connection to make sure it's valid. I put some steps together here.