I got a call today from a customer that wanted to upgrade SQL Server 6.0 to SQL 2000.

Problem...old tired server that may not survive a reboot, and no direct upgrade path.

Solution:
BCP the data out to text file, and find some 3rd party utility that can reverse engineer the schema.

We agreed to speak no more of this need. :-)