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. > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:241325 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
