How can I copy an SQL Database to another PC?

Question

copying the database with its instance without creating the database again and its tables.
-I copied a vbProgram and the SQL Query of the database connected to it to my PC. The problem is, we cant find the database that I copied to my PC.

Answer 1

When you say copy a SQL Database, do you mean the database files?



If it is the database files, you will need to attach them to a SQL Server installed on your PC.



If the copy is a database backup, then you will need to do a restore.



If the copy is a database script, then you will need to run the script to generate the objects.

Answer 2

If you have an older version of SQL, you can export your database via a DTS package. You can export the tables, stored procedures, views, permissions and data, or any of them separately. The newer versions of SQL upgraded from DTS to something else that is escaping my memory right now, but it's basically the same thing. The functionality is built into your SQL management Studio.

Answer 3

Above answer is notably solid, all i'd upload is that ASP.internet is in simple terms fantastic, there is notably much no longer something own homestead page can do this ASP.internet can not. the main important disadvantage of ASP.internet is that it incredibly is not any longer loose, who-ever runs your server has to purchase it from Microsoft. I desire own homestead page, yet ASP.internet is in simple terms as solid IMHO.

Answer 4

Hi,





Below link would provide information on database and SQL.



http://www.youtube.com/watch?v=4DkGuIKCcU4

http://www.youtube.com/watch?v=Kp4cFzz-bBI

Answer 5

55