sync between 2 tables - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

sync between 2 tables

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-02 : 02:24:42

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

52326 Posts

Posted - 2013-07-02 : 03:32:38

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

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-02 : 06:40:26

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

Thanks
Gangadhara

Thanks,
Gangadhara MS
SQL Developer and DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-02 : 06:49:56

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources