Have you tried the database publishing wizard. I think it creates scripts that are compatible with 2000.
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-4 2E0-A410-371A838E570A&displaylang=en -----Original Message----- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Monday, August 27, 2007 9:23 AM To: CF-Community Subject: SPAM-LOW: RE: Copy SQL Server DB Cool, doing that now. Thanks. > -----Original Message----- > From: Bruce Sorge [mailto:[EMAIL PROTECTED] > Sent: Monday, August 27, 2007 10:20 AM > To: CF-Community > Subject: RE: Copy SQL Server DB > > Create a data source on the machine. Crate a new MS Access database and > connect to that datasource, then import the tables. Then use SQL Server > 2000 > to import the tables. > > Bruce > > -----Original Message----- > From: Loathe [mailto:[EMAIL PROTECTED] > Sent: Monday, August 27, 2007 7:15 AM > To: CF-Community > Subject: RE: Copy SQL Server DB > > How do I even do that? > > All it seems to let me do is create scripts. > > > -----Original Message----- > > From: Bruce Sorge [mailto:[EMAIL PROTECTED] > > Sent: Monday, August 27, 2007 10:09 AM > > To: CF-Community > > Subject: RE: Copy SQL Server DB > > > > 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. > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241336 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
