InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 04:45:51 GMT20http://www.sqlservercentral.com/Forums/Topic1405226-364-1.aspxIf all you are doing is copying the data from one instance to another, then I would agree that replication is probably a far better solution. It sounds to me as if you are trying to develop something that is already built in. :-DFri, 11 Jan 2013 12:20:48 GMTBruce W Cassidyhttp://www.sqlservercentral.com/Forums/Topic1405226-364-1.aspx[quote][b]mpradeep23 (1/10/2013)[/b][hr]CDC works if tables are in different instances of sql sever?thank spradeep[/quote]Sure, CDC is an option but if you do not need a record of all historical data changes then it is likely overkill and still will not deliver real-time data to the downstream system. With CDC changes are queued on the source system. You'll still need a process to take those changes and push them to a downstream system which is likely going to best implemented as an SSIS package. Most types of SQL Server Replication require no development, only configuration. Have you looked into? I think you would be interested in Transactional Replication with a Push Subscription from your upstream system to your downstream system which requires no development and delivers as close to real-time data on the subscriber as possible.Thu, 10 Jan 2013 06:39:48 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1405226-364-1.aspxWhat about setting up replication for the table(s) in question?Thu, 10 Jan 2013 04:31:47 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1405226-364-1.aspxCDC works if tables are in different instances of sql sever?thank spradeepThu, 10 Jan 2013 04:17:31 GMTmpradeep23http://www.sqlservercentral.com/Forums/Topic1405226-364-1.aspx[quote][b]mpradeep23 (1/10/2013)[/b][hr]i have two tables in two sql servers i need two move data from one table to other on insert /update i had written a ssis package for this so when thier is update in one table then i need update it in to other table so for that can i call SSIS Package in Trigger so that will copy the data from source to destination thanks pradeep[/quote]Imagine a process on server 1 which has been written by a C# guy who knows nothing about set-based programming. He is inserting 10,000 rows one at a time in a loop in his program. Do you really want a trigger to execute an SSIS package 10,000 times in just a few seconds? Far better to run the package every few minutes & pick up any changes then. Or use CDC if you have a high enough version of SQL Server.Thu, 10 Jan 2013 02:28:05 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1405226-364-1.aspxi have two tables in two sql servers i need two move data from one table to other on insert /update i had written a ssis package for this so when thier is update in one table then i need update it in to other table so for that can i call SSIS Package in Trigger so that will copy the data from source to destination thanks pradeepThu, 10 Jan 2013 01:54:54 GMTmpradeep23http://www.sqlservercentral.com/Forums/Topic1405226-364-1.aspx[quote][b]mpradeep23 (1/10/2013)[/b][hr]Hi i trying call SSIS Package from a Trigger is there any perforamnce issue to the databasethanks in advance with best regardspradeep[/quote]Based on the limited information provided, my best answer is 'probably' and my advice would be to look for an alternative solution to whatever requirement you have been given.Thu, 10 Jan 2013 01:43:12 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1405226-364-1.aspxHi i trying call SSIS Package from a Trigger is there any perforamnce issue to the databasethanks in advance with best regardspradeepThu, 10 Jan 2013 00:03:03 GMTmpradeep23