Migrate database objects to new server

How to migrate all SQL 2000 objects (tables, views, SPs)
and users from current SQL server to a new SQL 2000
server in different domain? DO I need to modify DTS
packages?
Thanks in advance.
-DonHi
You could restore a backup or detach/attach the database. This should be
alot quicker.
See
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b224071
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
For DTS packages you can either follow the instructions in the second link
or use DTS backup utility from
http://www.sqldts.com/default.aspx?242
John
"Don Walter" <anonymous@.discussions.microsoft.com> wrote in message
news:8e2c01c3b5cf$38e49cb0$a601280a@.phx.gbl...
> How to migrate all SQL 2000 objects (tables, views, SPs)
> and users from current SQL server to a new SQL 2000
> server in different domain? DO I need to modify DTS
> packages?
> Thanks in advance.
> -Don|||Thank you John for your advice.
-Don
>--Original Message--
>Hi
>You could restore a backup or detach/attach the
database. This should be
>alot quicker.
>See
>http://support.microsoft.com/default.aspx?scid=kb%3ben-
us%3b224071
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q314546
>For DTS packages you can either follow the instructions
in the second link
>or use DTS backup utility from
>http://www.sqldts.com/default.aspx?242
>John
>"Don Walter" <anonymous@.discussions.microsoft.com> wrote
in message
>news:8e2c01c3b5cf$38e49cb0$a601280a@.phx.gbl...
>> How to migrate all SQL 2000 objects (tables, views,
SPs)
>> and users from current SQL server to a new SQL 2000
>> server in different domain? DO I need to modify DTS
>> packages?
>> Thanks in advance.
>> -Don
>
>.
>