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.