June 14, 2010 at 8:44 am
Hi,
I need to sync only 5 tables from a production database to another database. What is the best practice to sync only few tables from database to database ??
Regards
June 14, 2010 at 8:47 am
Mirroring is per database, and the mirror database is inaccessible. Doesn't sound like that's what you want.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2010 at 8:49 am
I need to sync every 5 minutes the data of few tables from one database to another..i guess I shoudl use Replication right ?
June 14, 2010 at 8:52 am
Yes. Transactional Replication would be the best option.
SQL DBA.
June 14, 2010 at 8:53 am
-- edit --
post irrelevant after the edit Sanjay made to his post.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2010 at 9:34 am
Okay.. I started to do the transaction replication (since I only need the changes for those tables) Ive my server on a Cluster and SQL is Standar version. Both databases are located on the same Server.
I followed this instructions: http://blogs.techrepublic.com.com/howdoi/?p=123
but, I got an error.. see print shot..
Please, any advice! its the first time that Im setting up a replication.
THANK YOU
June 14, 2010 at 12:12 pm
I made it work !
Thank you all for your help.. 🙂
always a pleasure to be guided for the experts !
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply