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

Sundaram Subramanian · 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

Insert same data in two different database simultaneously

Answers (5)