Post reply

RealTime Communication

  • 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.

  • 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

  • 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 

  • 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

  • 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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply