tru504187211
asked on
MS SQL Standard to Express Migration
Can anyone tell me the steps of moving from SQL Standard 2000 to Express 2005/ 2008 on the same machine?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you prefer that way, then your SQL Express instance installation should be done as a named instance.
Difference being Default instance would be referred as Servername and named instance would be servername\instancename.
Then you need to change the servername in all the applications that uses your database.
Difference being Default instance would be referred as Servername and named instance would be servername\instancename.
Then you need to change the servername in all the applications that uses your database.
ASKER