How to insert table values from one database to another database?

user_422829 0
Viewed 380372

I want a query to insert records from one table to another table in a different database if the destination table already exists, it should append the records at the end of the table.

integration append sql-server-2005 sql
10 Answers

Just Do it.....

( It will create same table structure as from table as to table with same data )

 create table toDatabaseName.toTableName as select * from fromDatabaseName.fromTableName;
user_84036890

Mostly we need this type of query in migration script

INSERT INTO  db1.table1(col1,col2,col3,col4)
SELECT col5,col6,col7,col8
  FROM db1.table2

In this query column count must be same in both table

user_28488580

If both the tables have the same schema then use this query: insert into database_name.table_name select * from new_database_name.new_table_name where='condition'

Replace database_name with the name of your 1st database and table_name with the name of table you want to copy from also replace new_database_name with the name of your other database where you wanna copy and new_table_name is the name of the table.

user_43604620

For SQL Server, you can use tool Import Data from another Database, It's easier to configuration mapping columns.

user_21445400
Related