How to export/import database

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

Re: How to export/import database

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" wrote in message news:f5al5a$btg$1@news.onet.pl...
> 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
>