Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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
52326 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
52326 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  
 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.02 seconds. Powered By: Snitz Forums 2000