Server Management - Systems Insight Manager
1748036 Members
4947 Online
108757 Solutions
New Discussion юеВ

How to move insight DB:s to MS SQL 2005

 
SOLVED
Go to solution
PeterN_UA
Advisor

How to move insight DB:s to MS SQL 2005

Hi we are planning to move insight and associated db:s to a mssql2005 running on win2003 64 bits OS.

Any hints or documents I can use to do this?

Anybody have experience with similar move or setup ??

Is it easier to do new setup ?
4 REPLIES 4
Daniel Leblanc
Honored Contributor
Solution

Re: How to move insight DB:s to MS SQL 2005

PeterN_UA
Advisor

Re: How to move insight DB:s to MS SQL 2005

locked through the document and it looks like useful when moving from msde to sql.

Im trying to move insight db from a remote SQL2000 server to a new SQL2005 server.

I stopped insight , moved insight db to new server , changed in odbc datasource - system dns the server and datbase to be used, started insight.

The problem is that connection is still to old db, what do i miss ??

reagards, Peter
Daniel Leblanc
Honored Contributor

Re: How to move insight DB:s to MS SQL 2005

Did you look at the connection to DB in the ODBC source date connector, under START>ADMINISTRIVE TOOL>ODBC DATA SOURCE Administrator
PeterN_UA
Advisor

Re: How to move insight DB:s to MS SQL 2005

Yes , I Thought this should be the chnage needed but it doesn't work for me...