copy database to server
-
Hi, I created a database (sql) and added tables and stored procedures to it using the .NET server explorer. Now I want to use the database created in a real server (thus move it from my development PC to a real web server). What is the way to do it? Do I need to create a database project to do that? Why does the .NET have databse projects if all can be done in the server explorer? If anyone knows any article about the subject please let me know. Thanks. avivhal
-
Hi, I created a database (sql) and added tables and stored procedures to it using the .NET server explorer. Now I want to use the database created in a real server (thus move it from my development PC to a real web server). What is the way to do it? Do I need to create a database project to do that? Why does the .NET have databse projects if all can be done in the server explorer? If anyone knows any article about the subject please let me know. Thanks. avivhal
Use DTS or simply sp_detach_db, copy the mdf & ldf files to the new server, and sp_attach_db. Michael I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970)