Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-20 : 06:53:17
|
| Edin writes "Hello I have one sql server ( win 2000 server) with main bases and I have two location with win 2003 server with additional bases.Evrithing is in the VFP 7.0 code linked woth SQL 2000. In main site evriting working OK. But now I data send by modems and updating bases every day manually. Plese describe what I need to do and wich hardware I need to link this points.On all points I have ISDN modems .Thanks" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-20 : 23:55:42
|
| How big are these databases, and how much data are you trying to transfer??? You could transfer the data directly between SQL Servers; however, you would have to open up the ports SQL Server communicates on to the whole world. This would, needless to say, create huge security risks. You might want to consider using ftp to move the data between sites. You could also write an application that will present data on one side and receive/process data on the other. MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Link two sql server