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 |
|
chriztoph
Posting Yak Master
184 Posts |
 Posted - 2009-07-28 : 05:54:59
|
| Hello!I have database1 and database2, what i want is if there is any changes in in database1 then automatically update the database2 without using restore or without accessing database2.Is it posseble?sample:if 1 table added in database1 then the table will automatically add to database2.. |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-28 : 05:59:44
|
| HiUse Replication...-------------------------R.. |
 |
|
|
chriztoph
Posting Yak Master
184 Posts |
Posted - 2009-07-28 : 06:29:10
|
| can i use this if they are in different server? |
|
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-28 : 06:32:05
|
| hiwhy not........Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.-------------------------R.. |
|
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-28 : 06:32:38
|
| http://msdn.microsoft.com/en-us/library/ms151198.aspx-------------------------R.. |
|
|
|
chriztoph
Posting Yak Master
184 Posts |
Posted - 2009-08-06 : 20:47:31
|
| i have a question in this replication.. if the Publisher/Distributor is Stop,is the subscriber can still go on? |
|
|
|
|
|
|
Create Database