SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL data Realtime to Web Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

emzipoo4u
Starting Member

United Kingdom
3 Posts

Posted - 07/25/2014 :  11:39:52  Show Profile  Reply with Quote
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

USA
36912 Posts

Posted - 07/25/2014 :  12:47:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

United Kingdom
3 Posts

Posted - 07/25/2014 :  12:55:03  Show Profile  Reply with Quote
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

USA
36912 Posts

Posted - 07/25/2014 :  13:09:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

United Kingdom
3 Posts

Posted - 07/25/2014 :  13:28:10  Show Profile  Reply with Quote
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

USA
36912 Posts

Posted - 07/25/2014 :  13:34:28  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000