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 |
|
drvuong
Starting Member
2 Posts |
 Posted - 2003-11-09 : 22:24:53
|
| We have several problems related to data transfer and seek helps from you professionals. Perhaps some description is worthwhile:1. Settings: We use one Internet SQL Server DB as main DB. One local SQL DB for the use of data within the group.2. We use the method of query to compare the ID of data records and the copy them from the Internet-based DB down to local DB. We find this way inefficient on several counts: (a) when there are changes in structure of the Internet DB, the querying process fails, so does the updating. (b) Much reliance on the Internet and connection performance.Now, our question:(i) Are there more efficient methods around so that we can synchronize data between the Internet DB and local; and between 2 local DB situated in different geoprahical positions?(ii) If we have a network that contains several SQL Server, at different locations, how should we organize so that the synchronizing of data amongst these servers is FEASIBLE and EFFICIENT, so that at the end we have same db at all different locations? Or at least one Central DB will have the fullest data of all other DBs?PLease help.Thanks a lot for your kind assistance,Vuong Q. Hoanghalf a bread is bread, half a truth is a lie |
|
|
dshelton
Yak Posting Veteran
73 Posts |
Posted - 2003-11-10 : 01:53:13
|
| You might want to look into replication. |
 |
|
|
drvuong
Starting Member
2 Posts |
Posted - 2003-11-10 : 04:18:18
|
quote:
Originally posted by dshelton
You might want to look into replication.
Can you please go more detailed about that? Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-10 : 12:27:38
|
| drvuong, replication is discussed in detail in SQL Server Books Online. Please consult that manual first. If you have specific questions regarding replication that BOL does not explain enough, then please post your question here.Tara |
|
|
|
|
|
|
Data transfer problems 'tween SQL db, Help wanted