Copying database from one instance to another

I am very very new at SQL and MSDE, however I have the following question,
hopefully an easy one.
We have been using an instance of MSDE on a slower smaller PC and recently
installed the SQL Server 2005 Express Edition Beta 2. We are not yet fully
going to this Beta yet.
How do I copy databases including tables with data over to this new
instance?
Thanks for the information.
Brad
"Brad" <ballison@.ukcdogs.com> wrote in message
news:uLpPF79pEHA.2456@.TK2MSFTNGP10.phx.gbl...
> I am very very new at SQL and MSDE, however I have the following question,
> hopefully an easy one.
> We have been using an instance of MSDE on a slower smaller PC and recently
> installed the SQL Server 2005 Express Edition Beta 2. We are not yet
fully
> going to this Beta yet.
> How do I copy databases including tables with data over to this new
> instance?
I'd recommend running a BACKUP of your database from MSDE, then RESTORE to
your copy of SQL Server 2005.
Steve
|||I recommend using sp_detach_db to disconnect the source database from the
Master database. This permits you to copy the MDF and LDF files to another
system. Once copied you can reattach with SQL Enterprise Manager or
sp_attach_db. In SQL Server Express (SS 2005) you can also use ADO 2.0 to
open an MDF file directly which automatically attaches the database (and
log) files unless they are already in Master. Otherwise you can use
sp_attach_db on the target system.
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:u6gBWt%23pEHA.192@.tk2msftngp13.phx.gbl...
> "Brad" <ballison@.ukcdogs.com> wrote in message
> news:uLpPF79pEHA.2456@.TK2MSFTNGP10.phx.gbl...
> fully
> I'd recommend running a BACKUP of your database from MSDE, then RESTORE to
> your copy of SQL Server 2005.
> Steve
>
|||That will certainly work, however one of the advantages of BACKUP/RESTORE is
only the data is copied from device to device. Database mdf and ldf files
will contain "empty" space.
Steve
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:%23A0beC$pEHA.2236@.TK2MSFTNGP09.phx.gbl...
> I recommend using sp_detach_db to disconnect the source database from the
> Master database. This permits you to copy the MDF and LDF files to another
> system. Once copied you can reattach with SQL Enterprise Manager or
> sp_attach_db. In SQL Server Express (SS 2005) you can also use ADO 2.0 to
> open an MDF file directly which automatically attaches the database (and
> log) files unless they are already in Master. Otherwise you can use
> sp_attach_db on the target system.
> hth
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> 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.[vbcol=seagreen]
> __________________________________
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:u6gBWt%23pEHA.192@.tk2msftngp13.phx.gbl...
to
>
|||Steve,
Being new to MSDE is this something that would be done from the command
line? What would the syntax be?
Thanks for the help.
Brad
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:u6gBWt%23pEHA.192@.tk2msftngp13.phx.gbl...
> "Brad" <ballison@.ukcdogs.com> wrote in message
> news:uLpPF79pEHA.2456@.TK2MSFTNGP10.phx.gbl...
> fully
> I'd recommend running a BACKUP of your database from MSDE, then RESTORE to
> your copy of SQL Server 2005.
> Steve
>
|||Brad,
Yes, you can use the OSQL utility to do this, from a command line prompt
type:
osql
to get the command parameters. I find it easiest to create a batch script
with the sql syntax.
The syntax (and examples) for the other 2 commands: BACKUP and RESTORE you
can get from SQL Server BOL (as there are many options depending on what you
need),.
If you have not downloaded BOL, it's free and an excellent resource:
http://www.microsoft.com/sql/techinf...2000/books.asp
Steve
PS if you run into any issues, please post the sy
"Brad" <ballison@.ukcdogs.com> wrote in message
news:eV%23k3BtqEHA.2612@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Steve,
> Being new to MSDE is this something that would be done from the command
> line? What would the syntax be?
> Thanks for the help.
> Brad
>
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:u6gBWt%23pEHA.192@.tk2msftngp13.phx.gbl...
to
>
|||hi Brad,
"Brad" <ballison@.ukcdogs.com> ha scritto nel messaggio
news:eV%23k3BtqEHA.2612@.TK2MSFTNGP15.phx.gbl
> Steve,
> Being new to MSDE is this something that would be done from the
> command line? What would the syntax be?
the syntax can be found at
http://msdn.microsoft.com/library/de...ra-rz_25rm.asp
but this can not be done directly by cmd... you have to resort on tools
able to connect to SQL Server, as, for SQL Server 2005, SQLCMD.exe, a
command line tool similar to OSQL.exe (documented in
http://msdn.microsoft.com/library/de..._osql_1wxl.asp)
please discuss SQL Server 2005 related problems/feauures int the public beta
newsgroups, that can be found at
http://communities.microsoft.com/new...r2005&slcid=us
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply