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 - 2003-07-02 : 07:18:49
|
| Edward writes "I have a Headquarters and several remote locations. All of the locations are running on SQL 2000. Our business need is to have a copy of the remote data in our headquarters. The data does not have to be real time (with-in a week would be ok or within a day would be better). We have small communications lines (Frame Relay 64k). We tried to use SQL replication but we could not get the initial data to come across our lines. Because of the expense of increasing the line speed, we are considering using the Log files to roll forward a database at our Headquarters. Can I use the log files to keep my Headquarters database up to date or is their a better alternative? Any advice, thoughts and/or comments you might have would be greatly appreciated. Thank you for your timeEdward Perez " |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-02 : 12:39:53
|
| Yes you could use the log files or you could just use the full backup as well. I have used the full backup solution before but the log file solution might be better for you if the database is big. The log file solution could be a tedious solution though.Tara |
 |
|
|
SQLScripter
Starting Member
2 Posts |
Posted - 2003-07-08 : 13:21:27
|
| Hi !i write a tool (freeware) which may help you.This tool script data in a T-SQL format.For example, you can choose your table, your fields and the type of action (INSERT, UPDATE ...). Then just create a connection with the Query Analyzer to your target server and run the file. Only the "commands" will be transferred over your line, and your target server does just his job.Just take a look:[url]http://www.sqlscripter.com[/url]Regards |
|
|
|
|
|
|
Data Replication over small communications lines