how can transfer data from one database to another database

Question

SELECT * INTO dbo.DB1.TempTable FROM dbo.DB2.TempTable how can set dbo.DB2 user id & Password to access data

Khargesh Rajput · Answer

Right click your databse as in below image Next Next if you want all tables data Next Click on advance And choose Data only if you have already created tables otherwise choose scheme and data below image check path to save srcipt then ok and next succes messge finish Now check in path where you saved srcipt file and now double click on script now script will open in sql and execute your query by select your another database Another way is If you want copy off your whole database in new db then you can just create a BAK file of your database and Restore on new database

Mohan Kate-Patil · Answer

hello Najim There are many ways are available to transfer data from one database to other Database. 1. But depends on which database you used. 2. You are try in Database directly or Use it in application Code Behind file. Please Mention your details more brief solution for you

Najim Mulla · Answer

khargesh rajput sir how can possible to send example

Khargesh Rajput · Answer

create scipt of one database with data and execute in another database

Afzaal Ahmad Zeeshan · Answer

Best way would be to use a database management system they would allow you to transfer data from one database to another maintaining all of the data of your database system. Writing your own code would not be a good idea. It would also take a lot of time and might cause other errors and data loss.