-1

I have two SQL Server

1st - 10.101.102.133 
2nd - 10.101.102.155

Both having the different database with different names and fields.

My application will update in the 1st server.

Can I actually configure the 1st server that once it received update query, it will update in 2nd server as well?

I want to insert data from 1st server to 2nd server by using trigger. when my Application insert data in a table in 1st server database a trigger will fire (insert trigger). and it pass the data in 2nd server by its user id and password.

How I write the script of this trigger?

Mohammad Hasan
  • 1
  • 2
  • The official documentation for whichever RDBMS you use will show you how to write a trigger. – Dale K Jun 17 '20 at 10:10
  • It"s SQL server Mr. Dale K. – Mohammad Hasan Jun 17 '20 at 10:12
  • 1
    And then read [create trigger](https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver15) and [Inserted/Deleted](https://learn.microsoft.com/en-us/sql/relational-databases/triggers/use-the-inserted-and-deleted-tables?view=sql-server-ver15) – Dale K Jun 17 '20 at 10:15
  • 1
    Look this about external data sources https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=sql-server-ver15 – Slava Rozhnev Jun 17 '20 at 11:29
  • 1
    Does this answer your question? [How to properly trigger an insert to a linked sql server?](https://stackoverflow.com/questions/22126993/how-to-properly-trigger-an-insert-to-a-linked-sql-server) – Venkataraman R Jun 17 '20 at 11:37

1 Answers1

1

Solved here: Selecting data from two different servers in SQL Server

You can use sp_addlinkedserver or Linked Servers approach.

Using sp_addlinkedserver would be something like this once you have set up the linked server:

select
    *
from
    LocalTable,
    [OtherServerName].[OtherDB].[dbo].[OtherTable]
rlm96
  • 193
  • 1
  • 15