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
>

• Next in forum: SQL - how to - minimum number of steps
• Prev in forum: Re: I need to find the rows that exist in one table but not in the other with condition
• Thread view: Re: How to export/import database

[Reply to this message]