Wednesday, March 7, 2012

MS SQL 6.5 -> 2000

Hi,

I must do an upgrade of one our server to SQL 6.5 to 2000 (don't laugh please !! lol)

I want to know how I can easily retrieve a database from a 6.5 to a 2000 edition.

I don't need the data, only the object (tables, index, sp, fk, etc)

I think to use DTS from an 2000 base pointing to an 6.5 base ?

Do you think it's possible ?

Or have you got better idea ?

Thanks and sorry for my poor english

Regards,

KevinThe article below might help:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx

No comments:

Post a Comment