how can transfer data from one database to another database

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

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

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

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.