Transfer data from one database to another database

Question

How to fetch the data from one database and insert in to another database table? I can't to do this. Please help me in transferring data from one to another.

Answer 1

There are several ways to do this, below are two options:

Option 1 - Right click on the database you want to copy

• Choose 'Tasks' > 'Generate scripts'

• 'Select specific database objects'

• Check 'Tables'

• Mark 'Save to new query window'

• Click 'Advanced'

• Set 'Types of data to script' to 'Schema and data'

• Next, Next

You can now run the generated query on the new database.

Option 2

• Right click on the database you want to copy

• 'Tasks' > 'Export Data'

• Next, Next

• Choose the database to copy the tables to

• Mark 'Copy data from one or more tables or views'

• Choose the tables you want to copy

• Finish

Answer 2

Example for insert into values in One database table into another database table running on the same SQL Server

insert into dbo.onedatabase.FolderStatus (   [FolderStatusId],   [code],   [title],   [last_modified] )  select [FolderStatusId], [code], [title], [last_modified] from dbo.Twodatabase.f_file_stat