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 |
|
Brian_Burgit
Starting Member
2 Posts |
 Posted - 2004-11-15 : 14:21:47
|
| We have a web site that runs against a SQL server database at our host. We are starting to develop a new internal application that will also be SQL server based. Many of the tables in both databases will be the same, and we would like the data in both to be updated realtime. For example, if a web customer buys a product, we would like that purchase reflected in both databases? Is the best approach to have my internal system run against the database at the host for the tables that are the same? What other options do I have?Thanks,Brian |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-15 : 17:32:15
|
| You can use transactional replication.Tara |
 |
|
|
Brian_Burgit
Starting Member
2 Posts |
Posted - 2004-11-15 : 18:51:12
|
| Thanks Tara. Do you know if this is generally a reliable and good performing service? Is it the Preferred method? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-15 : 18:53:23
|
| Yes it is reliable although a little difficult to troubleshoot when problems arise if you aren't familiar with it. There are some tweaks to be made to make it perform better. You could also use a two phase commit over distributed transaction coordinator. I wouldn't be able to provide much help on that though.Tara |
|
|
|
igbinosun
Starting Member
13 Posts |
Posted - 2004-11-15 : 20:29:19
|
| Use transactional replication or use distributed transaction to update tables on both servers at the same time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-16 : 12:21:17
|
| Isn't that what I said?Tara |
|
|
|
|
|
|
Configuration for databases at 2 locations