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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL data Realtime to Web Server

Author  Topic 

emzipoo4u
Starting Member

3 Posts

Posted - 2014-07-25 : 11:39:52
Hi Guys

Not 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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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.
Go to Top of Page

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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.
Go to Top of Page

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -