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 |
|
emzipoo4u
Starting Member
3 Posts |
 Posted - 2014-07-25 : 11:39:52
|
| Hi GuysNot sure which category this falls into but I wonder if someone can point me in the right direction.On one of our local servers we have an SQL database. We also have another database on our web server. Currently we update stock on our web server via DTS once a day. I would like to make this real-time so customers can always see our correct stock. How can this be done ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-25 : 12:47:35
|
| You can use transactional replication for this. Latency should be just a couple of seconds, except when you have large transactions (such as an index rebuild) that affects the table in the publication. How latent it'll be in that case will depend on the size of the large transaction and your hardware resources.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
emzipoo4u
Starting Member
3 Posts |
Posted - 2014-07-25 : 12:55:03
|
| Will this only push out updates, I dont want it to receive anything from the web server because of security issues. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-25 : 13:09:26
|
quote:
Originally posted by emzipoo4u
Will this only push out updates, I dont want it to receive anything from the web server because of security issues.
It does whatever you configure it for. It can be one-way or two-way. It is almost always setup as one-way. I've never set it up to be two-way and have been using it for many years.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
emzipoo4u
Starting Member
3 Posts |
Posted - 2014-07-25 : 13:28:10
|
| The database i want to push out to is 2005 express version. Will this work and can you connect with a connection string. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-25 : 13:34:28
|
| Connection string has nothing to do with replication. I believe one-way transactional replication is available in 2005 express. You'll need to check though.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
SQL data Realtime to Web Server