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. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241324 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
