Copy Database Wizard

Hello at all,
I want to transfer sql2000 databases and DTS from machine to another; I have
tried to use "Copy Datebase Wizard", but I'm not sure this is the best
choice. Does anyone want to help me?
thank youhi
see my blog
http://oneplace4sql.blogspot.com/
--
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
> Hello at all,
> I want to transfer sql2000 databases and DTS from machine to another; I
> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
> best choice. Does anyone want to help me?
> thank you|||Thanks a lot.
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>> Hello at all,
>> I want to transfer sql2000 databases and DTS from machine to another; I
>> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
>> best choice. Does anyone want to help me?
>> thank you
>|||Another question. what does occur if don't copy master database to target
machine?
Can I restore all DB with sql backup/restore utility? It's the same?
Thanks
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>> Hello at all,
>> I want to transfer sql2000 databases and DTS from machine to another; I
>> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
>> best choice. Does anyone want to help me?
>> thank you
>|||Hi
You can restore master database restore backup cmd. Microsoft recomended way
is using sqlcmd tool
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
--
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:eHwb62FnHHA.4196@.TK2MSFTNGP06.phx.gbl...
> Another question. what does occur if don't copy master database to target
> machine?
> Can I restore all DB with sql backup/restore utility? It's the same?
> Thanks
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
>> hi
>> see my blog
>> http://oneplace4sql.blogspot.com/
>> --
>> VT
>> Knowledge is power, share it...
>> http://oneplace4sql.blogspot.com/
>> "acolmano" <acolmano@.tin.it> wrote in message
>> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>> Hello at all,
>> I want to transfer sql2000 databases and DTS from machine to another; I
>> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
>> best choice. Does anyone want to help me?
>> thank you
>>
>