SIMS MSDE

[ndavies]

This appears to even myself as a stupid question but I just need confirmation..after migration, I need to stop the old instance of the SIMS db running on MSDE, right?

I'm scared to do this because of the two errors in this...

SIMS System Information Report
==============================

Server Name: EDMUND\SIMS2005

Database Name: SIMS

Database Version: <ERROR: Cannot find file 'C:\Program Files\SIMS\SIMS .net\MSSQLDBV.INI'>

Platform Version: <ERROR: Cannot find file 'C:\Program Files\SIMS\SIMS .net\LOCAL.MEM'>

Workstation Version: <NONE>

MDAC Version: 2.81.1117.0

Windows Version: Windows XP - Version 5.1 (Build 2600: Service Pack 2)

Processor: x86 Family 15 Model 6 Stepping 4 - GenuineIntel

Physical Memory: 495MB

Total Memory: 1.13GB

(Generated by SIMS System Manager Module on 16/10/2007)

[splattthecat]

The migration process should automatically detach the SIMS database from the MSDE instance and attach it to the SQL Express instance.

[ndavies]

You'd think so, but I'm fairly surely the MSDE instance is still running?!

[Uraken]

msde will still be running sims took the decision to do a side by side install of sql 2005 not an inplace upgrade just in case you have other stuff other than sims that requires the msde still.

[ndavies]

yes we do. we have backup exec, rm portal and WASP inventory instances still running but what i'm saying is that the sims instance is still running is msde. how do i know that sims isn't still using that one. stop it?!!!!!

[splattthecat]

The SIMS instance will still be running, but there should be no SIMS database attached to that instance after migration. This can be tested by either running dbAttach and seeing what databases are available on the MSDE instance to detach, or trying to copy the SIMS.MDF & LDF. (You won't be able to copy them if they are still attached)

[cophighschool]

The migration process should redirect the old instance to the new 2005/express, sort of similar to a redirection that the royal mail do when you move house.

[cophighschool]

The migration process should redirect the old instance to the new 2005/express, sort of similar to a redirection that the royal mail do when you move house.

[ndavies]

In the end I checked the connect ini files to ensure they were looking at the right instance...then i stopped the old one and waited for the calls to coming flooding in..nearly two days later..nada!!