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.
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. 🙂