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 |
|
andrewnm
Starting Member
5 Posts |
 Posted - 2013-04-26 : 06:32:14
|
| I am currently trying to integrate 2 databases.- we have 2 databases running independently and we would like to integrate the 2 and have database A update database B after every 15mins.below are the tasks i want to accomplish.1.create a staging table1 in database A and have the other tables update in database A this table 2.create a similar table2 in database B have several table in the database read from this table.3. have table1 in database A update table2 in database Bplease advice on how to go about it. thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-26 : 06:35:28
|
| hmm...why cant you set up replication between them? sounds like merge replication to me------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
andrewnm
Starting Member
5 Posts |
Posted - 2013-04-26 : 07:38:59
|
| thanks....how do i setup this replication merge....ive never done this before |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-26 : 07:42:41
|
| http://www.codeproject.com/Articles/28951/SQL-Server-2005-Merge-Replication-Step-by-Step-Pro------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
intergrating 2 dbs that are different server