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 - 2004-01-08 : 08:09:48
|
| ANDRE writes "I am using Macola software with an SQL backend and I am interested in having another copy of the SQL database with the Macola frontend at another location (offsite location) for the end users to enter and update static and transactional data and would like this to update the SQL database at head office with any changes to the static data as well as any new transactional information. I am not to clear as to how to do this. Would replication work because I need both locations to carry different invoice sequencing and location id tags." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-08 : 12:26:00
|
| You would need to implement merge replication. Read all about it in SQL Server Books Online.Tara |
 |
|
|
|
|
|
SQL Database replication