How to export/import database

#1

Hi

I`ve Ms SqlExpress 2005 and question how to export/import all databases
to/from file.
Bcp.exe can do it but only for a table I think.

Pls help

Mirek

#2

For entire databases. consider backup/restore. After restoring to a
different server, you may need to create/remap logins. See
sp_change_users_login in the Books Online for details.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"mw" <mbw (AT) vp (DOT) pl> wrote

Quote:

Hi

I`ve Ms SqlExpress 2005 and question how to export/import all databases
to/from file.
Bcp.exe can do it but only for a table I think.

Pls help

Mirek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to export/import database

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

How to export/import database - 06-20-2007 , 02:35 AM

Re: How to export/import database - 06-20-2007 , 05:32 AM