Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

TMS SQL 2005 DB to SQL 2008

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

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

TMS SQL 2005 DB to SQL 2008

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

4 REPLIES
Cisco Employee

TMS SQL 2005 DB to SQL 2008

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.

TMS SQL 2005 DB to SQL 2008

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

Thank you,
Justin Ferello
Technical Support Specialist, ScanSource KBZ

TMS SQL 2005 DB to SQL 2008

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.

Please remember to rate helpful responses and identify

Cisco Employee

TMS SQL 2005 DB to SQL 2008

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

622
Views
0
Helpful
4
Replies
CreatePlease to create content