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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sync between 2 tables
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gangadhara.ms
Aged Yak Warrior

India
547 Posts

Posted - 07/02/2013 :  02:24:42  Show Profile  Reply with Quote
Hello,

As we are moving to new CRM application,from current legacy CRM we need to sync some tables of existing system to new CRM tables.

Please suggest to do this in SQL server 2005,Any reference link will be helpful.


Regards,
Ganga

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 07/02/2013 :  03:32:38  Show Profile  Reply with Quote
If its single time operation, use backup restore. If you want it to continue for a period try replication

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

gangadhara.ms
Aged Yak Warrior

India
547 Posts

Posted - 07/02/2013 :  06:40:26  Show Profile  Reply with Quote
If i need to replicate one or 2 table please suggest.

Thanks
Gangadhara

Thanks,
Gangadhara MS
SQL Developer and DBA
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 07/02/2013 :  06:49:56  Show Profile  Reply with Quote
quote:
Originally posted by gangadhara.ms

If i need to replicate one or 2 table please suggest.

Thanks
Gangadhara

Thanks,
Gangadhara MS
SQL Developer and DBA



you need to create a publication for that and add required tables as articles
there are different type of replication like transaction,merge,snapshot so based on your requirement you may need to use one of them

more details here

http://www.sqlservercentral.com/stairway/72401/

------------------------------------------------------------------------------------------------------
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.12 seconds. Powered By: Snitz Forums 2000