/SQL/Copy data from one database to another

Copy data from one database to another

Migrate sql table another database

INSERT INTO dbo.YourTableNameHere
   SELECT *
   FROM [SourceServer].[SourceDatabase].dbo.YourTableNameHere

5

Copy data from one database to another

Copy CodeSelect * into DestinationDB.dbo.tableName from SourceDB.dbo.SourceTable

0

Source: codeproject.com

Similar codes

0 vote164 views1 answer
Oracle list proxy users
SQL
0 vote160 views1 answer
IIF
SQL
3 votes158 views2 answers
Postgres download
SQL
1 vote182 views1 answer
Mysql add fields
SQL
0 vote166 views1 answer
Mysql export search results
SQL
0 vote185 views1 answer
Query builder doctrien return sql
SQL
0 vote135 views1 answer
Oracle sql replace string in clob
SQL
15 votes363 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote164 views2 answers
How to relationship query two different tables in MySQL
SQL
2 votes154 views1 answer
Wait delay in sql server
SQL

Share