Currently, we have three workstations in the field. Each one has Windows XP Server and SQL Server Express 2005 installed on them. So they operate locally for now.

But our customer added two servers to the system. These two servers have Windows 2003 Server and SQL Server 2005 Standard installed. All three workstations will use these common databases on the servers.

So, what is the easiest way to achieve this? Is it possible to move workstation databases to servers?

Thanks in advance.

migrated from stackoverflow.com May 18 '11 at 7:44

This question came from our site for professional and enthusiast programmers.


Do a backup of each of the databases on the workstations and then restore them on the server, as easy as that. Remember to change the connection strings of the applications to point to the new server



Edit After Comment

It is important to note the version, and I am unsure if Standard supports any of the below, you will have to make sure.

Interms of using the workstations as failovers there are a couple of options:

  1. Log Shipping
  2. Database Mirroring
  3. Replication

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy