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 |
|
baranozgul
Starting Member
20 Posts |
 Posted - 2005-01-25 : 07:08:40
|
| Hi all,I have the following scenario.I have a software testing system. There is a central database for keeping all test data. Tests are conducted with applications at remote locations. Each application has its own local database.I want the locally collected test results, transferred to central database regularly. I also want to keep the uniqueness of records at the central database.central tests table is as follows:ID TESTDATE RESULT TESAGENT1 24.01.2005 85.6 Josh2 25.01.2006 66.4 MarkHow can I overcome this requirements with replication?Sincerely,- Baran Ozgul |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-25 : 17:38:31
|
| You could use Transaction Replication. I would read up on SQL Server Replication in SQL Server Books Online for more information.Tara |
 |
|
|
|
|
|
replication Scheme