943,571 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 1284
  • MS SQL RSS
Dec 30th, 2008
0

database copying from local to server

Expand Post »
Hi all,

I am new to sql programming, How can we copy a database from a local system to server?

Thanks in advance,
karthik.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
kodingkarthik is offline Offline
37 posts
since Dec 2008
Dec 30th, 2008
0

Re: database copying from local to server

I didn't understand you, what you mean by "copying database" is to copy its data or copy the files?
If you need to copy its data right click on the database->All tasks->Copy database
If you need to copy its files to move it to another machine; right click on the database->All tasks->detach
then copy physical database files from its location on existing machine then paste them to the another machine (the server in your case) then right click on databases->attach database->select it from its location
Featured Poster
Reputation Points: 480
Solved Threads: 276
Postaholic
Ramy Mahrous is offline Offline
2,189 posts
since Aug 2006
Dec 30th, 2008
0

Re: database copying from local to server

Thanks for your reply and i have copied the database by right clicking on the database we have Export Data but i have copied the table to the master database.
Is there any problem if i put my table in master dB?
Reputation Points: 10
Solved Threads: 0
Light Poster
kodingkarthik is offline Offline
37 posts
since Dec 2008
Dec 30th, 2008
0

Re: database copying from local to server

I think there's no problem but Master database has another usage by SQL Server itself, first create another database and copy your data into instead of Master database.
Featured Poster
Reputation Points: 480
Solved Threads: 276
Postaholic
Ramy Mahrous is offline Offline
2,189 posts
since Aug 2006
Dec 30th, 2008
0

Re: database copying from local to server

ok Thank u for your reply I wil make the necessary changes
Reputation Points: 10
Solved Threads: 0
Light Poster
kodingkarthik is offline Offline
37 posts
since Dec 2008
Dec 30th, 2008
0

Re: database copying from local to server

Please if your problem solved, mark this thread as solved
Featured Poster
Reputation Points: 480
Solved Threads: 276
Postaholic
Ramy Mahrous is offline Offline
2,189 posts
since Aug 2006
Jan 9th, 2009
-1

Re: database copying from local to server

I think that it needs to be pointed out here that the MASTER database should NEVER be used to hold user entities. Niether sould ANY of the other SYSTEM databases (MSDB, TEMPDB).

MS often changes items within the system databases and would not hesitate to overwrite (or more likely crash on) user entities which have been placed in these DB's.

ALWAYS create you own database for your own use. However you move the DB's from User Aceptance etc to LIVE / Production (and there are numerous ways to do this.)
Reputation Points: 33
Solved Threads: 9
Junior Poster
pclfw is offline Offline
132 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: selecting from other tables with information from the main table
Next Thread in MS SQL Forum Timeline: Allowing NULL search in SelectCommand of SQLDataSource





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC