Question SQL Server to SQL Express

Arg81

Well-known member
Joined
Mar 11, 2005
Messages
949
Location
Midlands, UK
Programming Experience
1-3
I have an application that connects to a SQL Server (2000).

This application is used by 4 global sites, and each site connects to the UK (HQ) and then accesses their database from the SQL Server.

I want to move these databases off of the SQL Server and into an SQL Express database.

I assume all I need to do is install SQL Express 2005/2008 on the local servers, move the databases across, then change my application's connection string?
 
Back
Top