Click here to Skip to main content
14,333,875 members
Rate this:
Please Sign up or sign in to vote.
See more:
I have two same database. one database place at local sql server and another at webServer sql.So my quetion is I want the inserted data into local server Database is automatic update at Webserver Sql database. Is sql have some features to do it?.
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

It depends what you mean by automatic update. SQL Server does support mirroring
http://msdn.microsoft.com/en-us/library/ms189852.aspx[^]

If this doesn't suit then you can use SSIS http://msdn.microsoft.com/en-us/library/ms141026.aspx[^]
and create a SQL Server job

Or, add a trigger to the table(s) and use a linked server connection to update the other database when a row is added or updated.
   
Comments
Uday P.Singh 13-Jun-11 17:22pm
   
good answer my 5+

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100