RealTime Communication

• kanaparthi2000

  Old Hand

  Points: 345

  More actions

  February 27, 2008 at 5:32 am

  #128001

  Hi All,

  I have a one requirement, Any Insertions or Updations in one table immediately it will effect into another table.

  Here table names and column names are different and two different machines.

  Here i am using SQLServer2000 Database in both machines.

  Any ideas, Suggestions...

  Thanks in Advance.

  Regards

  Kanaparthi.

• henri flokstra

  SSC Eights!

  Points: 939

  More actions

  February 27, 2008 at 6:05 am

  #782454

  Perhaps your solution is in making triggers on the tables that are affected.

  Especially when table and column names differ in the two configurations.

  ------------------------------------------------------------
  Application Architect and Developer @ Traffic4u
  Visit my profile on LinkedIN

• Irish

  Hall of Fame

  Points: 3958

  More actions

  February 27, 2008 at 6:41 am

  #782465

  In this case you can use Triggers and a Database Link. The link will allow you to refer to the Database located on the other Server just the same as if it were located in the same Instance. You would also need a link if you were to write information between instances.

  Alternatively, you could use Replication, but that is better reserved for entire Databases worth of data rather than just a table or two.

  Regards, Irish 

• henri flokstra

  SSC Eights!

  Points: 939

  More actions

  February 27, 2008 at 6:49 am

  #782470

  Here table names and column names are different and two different machines.

  Can't do that with replication.. You'll need a dts package with that and transform data.

  ------------------------------------------------------------
  Application Architect and Developer @ Traffic4u
  Visit my profile on LinkedIN

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 27, 2008 at 9:02 am

  #782592

  You need it to happen immediately. You create a linked server to the other server. then create a trigger on the table for insert and update and then fire the change on the other server too.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com