Leaving aside the advisability of doing this :) I have detached and reattached SQL 05 express DBs to prod servers and vice versa - and I will give you a qualified "Yes" that what you want to do will work.
Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Mike Kear [mailto:[email protected]] Sent: Monday, January 04, 2010 8:05 PM To: cf-talk Subject: SQLServer Express and SQLServer - totally compatible? I'm building a second machine which will run CF on it, and will need to manipulate my SQLServer2005 databases on a network server. I'm going to be connecting this machine to these databases on an external drive as though they're local, because i'm going to be swapping back and forth between these machines regularly. I dont want to keep attaching and detatching lots of databases - i'd rather just connect the external database to this machine and then boot it up. So if i have SQLServer2005 (the full version) driving the databases when I'm working at one location, and SQLServer2005 Express driving the databases when I'm working at my other location, will that cause problems in the databases? Are the two versions fully compatible at least as far as database file structure etc is concerned? I should also add that I'm only going to be using the Express on a dev machine - not connected to the internet, and there wont be multiple users. And i hardly ever use the advanced features of the database for these little applications - things like syndication and triggers etc - i prefer to have ColdFusion take care of all those kinds of jobs. So for the most part, the databases are simple data storage mechanisms, with all the processing of data being done in ColdFusion. Can anyone see a problem if i do this? I'm not sure the machine I'm building justifies the cost of buying a licence for SQLServer2005 the full version. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
