Posted by Dan Guzman on 06/20/07 10:32

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@vp.pl> 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
>

[Back to original message]