[dba-SQLServer] nstalling SQL 2000 on a server that already hasSQL 2003

Hi Robert:

Your right off course there is no MS SQL 2003... late night or drugs take
your choice.

That is the answer I was looking for. I will try the import package later as
it is currently on a 'down for service' server.

Thanks
Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L.
Stewart
Sent: Thursday, July 13, 2006 10:52 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] nstalling SQL 2000 on a server that already
hasSQL 2003

Jim,

There is no such thing as SQL 2003.  So, assuming you installed SQL 2005
which
is the only release after SQL 2000, you use SQL Server Management Studio and
connect to the server.  Then go to management, Legacy, Data Transformation
Services.  You can import a package file or use the migration wizard from
there.

But, I believe you will have to have SQL 2000 running on the system to do
this.

Robert L. Stewart
The Dyson Group International
Software for the Non-profit Enterprise
Expanding your Sphere of Knowledge


Quoting dba-sqlserver-request at databaseadvisors.com:

> Date: Thu, 13 Jul 2006 08:16:03 -0700
> From: Jim Lawrence <jlawrenc1 at shaw.ca>
> Subject: Re: [dba-SQLServer] Installing SQL 2000 on a server that
> 	already	has SQL 2003
> To: dba-sqlserver at databaseadvisors.com
> Message-ID: <0J2C00FO1KWYZ630 at l-daemon>
> Content-Type: text/plain; charset=us-ascii
>
> Hi All:
>
> Thanks Francisco and Steve:
>
> Thanks for the information. Actually it is a 2003 Server with MSSQL 2003
> installed. It appears that I got a little ahead of myself when I rebuilt
the
> server not first installing SQL 2000 as I figured clients would be
migrating
> to MS SQL 2003. This was not the case and one client would like a bit of
> development work done on the SQL 2000.
>
> All the objects from the MS SQL 2000 had exported and imported into the MS
> SQL 2003 without issues but the DTS package information did not come
across.
> Fortunately, the information was also exported as SQL but I still can not
> get it imported and it will be very time consuming to re-write it all
again.
>
> Am I missing something simple and obvious or do the DTS packages have to
be
> all re-keyed??? So far I have been unable to find any information on the
> subject....
>
> On the other hand having a MS SQL 2000 on the system would resolve these
> issues but that could cause more problems than it would solve. After a
bout
> with a Beta SQL Express which required the complete re-install of our
> production server caution is the key-word. (NO DOWNTIME!!)
>
> If you have any information on the subject or location where I could look
> for information I would be greatly appreciative.
>
> Jim


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com