Insert same data in two different database simultaneously

Question

Hi Any one can help me please i want insert same data in two different database simultaneously. While both database has same table and their schema.... thanks

Sundar · Answer

There is one concept as SQL Replication where you can create more database connection. Here I have pasted the links kindly have a look 1) https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication 2) https://stackoverflow.com/questions/153988/how-can-i-copy-data-records-between-two-instances-of-an-sqlserver-database Hope these may helps you. thanks in advance.

Nilesh Shah · Answer

I assume both of them are SQL Servers if so you can create a link between those using linked servers feature on insert in any one server use after insert trigger on table to insert on another server table

Pramod Thakur · Answer

You can write a procedure for it. Create Proc [Procedure_Name] @Param1 datatype @Param2 datatype @Param3 datatype as Begin Insert into [DatabaseName].[SchemaName].[TableName] values (@Param1@Param2@Param3) Insert into [SecondDatabaseName].[SecondSchemaName].[SecondTableName] values (@Param1@Param2@Param3) End

Amit Gupta · Answer

You can try Use [database1] // Insert query Use [database2] // Insert query

Manas Sahoo · Answer

Hi Nilesh can you provide me link to create link server using Sql Server step by step