TMS SQL 2005 DB to SQL 2008

[JensLantermann]

Hi,

I have here a nice problem. We had an old TMS Server (v.13.1) installed at MS 2003 R2 with SQL 2005.

The export of the DB was no problem.

Now we need to upgrade the OS to MS 2008 R2 64bit. We had installed the TMS Version 13.1.2 with SQL 2008.

How can I import the old DB to the new TMS?

Who has an idea or had it done?

Greetings

Jens Lantermann

[daleritc]

When you say "export of the DB", do you mean you have a backup of the 'tmsng' db or you've detached the entire 'tmsng' db from the former SQL server? Depending of what you've done will depend on how you proceed with regards to migrating the tmsng db to the new SQL server.

But let's assume you've detached and have the entire tmsng db, then you can simply utilise MS SQL Server Management Studio to detach the tmsng db to the new SQL server and when you go to install TMS to the new TMS server, then utilise custom install and when you get to the db part, simply point to the new SQL server where the tmsng db now resides.

Keep in mind, and from your description above, it appears you've already installed TMS to the new TMS server...meaning I'm assuming you've created a 'new' tmsng db on the new SQL server. If that's the case, and again using SQL Management Studio, you then simply need to detach and remvoe  the 'new' tmsng' db and replace it with the tmsng db from the former SQL server, i.e. attach the former tmsng to the new SQL server.

[Justin Ferello]

Dale,

His old DB was from TMS 13.1 and his new TMS server is running TMS 13.1.2.  Would he not have to downgrade the new server to 13.1, restore the DB, then run the TMS 13.1.2 install again?  Or is there another way to manually upgrade the SQL DB from 13.1 to 13.1.2?

Thanks,

Justin

[Martin Koch]

If I remember it correct from an older TMS DB guide MS SQL stores the local path

in the DB as well, so you might need to fix that if the path of the SQL DB changed

with the new information.

I will not hope that MS makes a difference as well if its 32(old) vs. 64bit, ...

Besides that the I would see that I first get rid of the TMS13.1 install, get up the 13.1 DB on the new SQL server

and then just do a fresh install of TMS 13.1.2 which should upgrade the database.

If the TMS agent (movi/findme) was used do not forget to restore the tms agent / opends database as well.

[daleritc · Accepted solution]

Ditto on what Martin says with regards to Justin's questions