You could esport it from SQL 2005 to Access, then back to SQL 2000. You will probably lose the FK relationships and the PK's. Print out the relationship diagram to help with the constraints and what not. That is the fasted way I can think of it.
Bruce -----Original Message----- From: Loathe Sent: Monday, August 27, 2007 7:04 AM To: CF-Community Subject: RE: Copy SQL Server DB Ugh, how do I change it? Our production servers are still 2000. I guess I need to recreate it. Damn, I'm pretty anal about table design and enforcing relationships, fks and so forth. This is like 6 hours of work. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241322 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
