transfering database from one pc to others using msde

[Cc]

hi,
how do I transfer database create using vs.net on one pc to other pc using
msde. I don't see any tool provide with msde to export and import database.

 

[William \(Bill\) Vaughn]

There are several techniques, but I like to use the tools to detach the SQL
Server database and re-attach the files on the target system. This is harder
without the tools (in SQL Enterprise Manager), but you can still use
sp_detach_db
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_83fm.asp
and sp_attach_db to reattach the files.

hth

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Glenn Wilson]

I have seen a lot of people use the detach methods in the news groups, Just
a quick question, Why wouldn't you just use the backup and restore methods,
it would then create the database's file structure on the disk a lot cleaner
then with the attach restore.

Also I would just like to add that after I have move a development database
into a production system, I would make sure that I ran a dbreindex, and a
checkdb just to make sure the transfer was completed properly. You also have
to make sure that you remap the logon's that are needed as reattaching or
restoreing the database would not transfer the logins, only the user
accounts for the database in question.

Glenn Wilson.

 

[Joe Fallon]

I use backup/restore and fix the user accounts.
Works fine.