We are outsourcing one of our projects to another company. So on this other company they are going to have a SQL Server 2000(say SQL1) server. In our company we are going to have a SQL Server 2000 (say SQL2). Once a week we are planning to dump the data from that SQL1 to SQL2. I don’t know how feasible this is, is it feasible? How do I connect the two servers? The connection option I can think of is dial up. Not a dedicated line. What is the best way to do this? What are my options?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
transfering data between two servers.
- Thread starter shaminda
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question