I'm glad it worked for you. It's nice to offer a tip for once instead of always just posting questions. ;)
-----Original Message----- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Monday, August 27, 2007 6:21 PM To: CF-Community Subject: SPAM-LOW: RE: Copy SQL Server DB This worked perfectly, thanks man, an invaluable tool. > -----Original Message----- > From: Matthew Smith [mailto:[EMAIL PROTECTED] > Sent: Monday, August 27, 2007 11:33 AM > To: CF-Community > Subject: RE: Copy SQL Server DB > > 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. > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:241411 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
