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
 General SQL Server Forums
 New to SQL Server Programming
 intergrating 2 dbs that are different server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

andrewnm
Starting Member

Kenya
5 Posts

Posted - 04/26/2013 :  06:32:14  Show Profile  Reply with Quote
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 B

please advice on how to go about it. thanks

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/26/2013 :  06:35:28  Show Profile  Reply with Quote
hmm...why cant you set up replication between them? sounds like merge replication to me

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

andrewnm
Starting Member

Kenya
5 Posts

Posted - 04/26/2013 :  07:38:59  Show Profile  Reply with Quote
thanks....how do i setup this replication merge....ive never done this before
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/26/2013 :  07:42:41  Show Profile  Reply with Quote
http://www.codeproject.com/Articles/28951/SQL-Server-2005-Merge-Replication-Step-by-Step-Pro

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
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.41 seconds. Powered By: Snitz Forums 2000