Posted on 2006-05-24
we are merging 2 offices which are about 200 miles apart.
We will be installing a VPN on each end using a windows 2003 server as the primary domain in one location (lets call it A)and another Windows 2003 Server with a trust relationshio at the other location(lets call it B).
Both buildings currently are using Timeslips Database. We want to combine the 2 databases together(or should I say the information.. and have the new database reside on the Windows 2003 DC computer at location A.
There is a T-1 connection to the internet in the location with the DC computer (A)and a cable modem connection to the internet at the other location(B).
The timeslips databases in each locataion are 2 different versions so I know I must upgrade to the same version for all computers.
What we want to happen is use B's Timeslip Database and move A's info into B.
Where it gets complicated is that we want to move the location of B's Database to A's location.
Can someone please tell me if this is possible to just copy the database and what is involved or is there more to it.
Mappped drives? Also, someone mentioned that I need to consider each's configuration file??? Please explain.
Based upon the slower Cable modem connection to the internet in location B do you think there will be slow access to the database at location A.
One more thing.. There are 3 users in Location A and 10 users in Locatin B.
Need resolution asap.
Thanks in advance