insert one table record from 1 db to another db

INSERT INTO dbo.TargetTable(field1, field2, field3)

SELECT field1, field2, field3

FROM SourceDatabase.dbo.SourceTable

WHERE (some condition)

Hi Riya,

 

Insert into newdatabase.tableName(column1,column2)

select  column1,column2 from olddatabase.tableName

 

Your both table structure should be same in this case.

 

https://stackoverflow.com/questions/22912167/mysql-insert-into-from-one-database-in-another 

Hi Riya singh

 

Please use these links 

 

https://www.sqlshack.com/how-to-copy-tables-from-one-database-to-another-in-sql-server/

 

https://www.c-sharpcorner.com/blogs/insert-values-from-one-database-table-to-another-database-table-in-sql-server1 

 

https://docs.microsoft.com/en-us/sql/relational-databases/tables/copy-columns-from-one-table-to-another-database-engine?view=sql-server-2017