Just a thought: if you're carting an external disk back and forth, why not put a VM with SQL Express and your databases on that disk? Personally I run a little VM farm with SQL and CF all off the one eSATA disk. All is kosher as far as SQL is concerned, and if you need to get data onto another server you've still got linked servers and/or SSRS, or even just a file copy of the results of your processing.
BTW, I would not be at all suprised if SQL had some kind of fit when your database files arrive back from wherever with a big hole in their LSN's. It's precisely for this reason that detaching/reattaching is necessary. Jaime On Tue, Jan 5, 2010 at 12:05 PM, Mike Kear <afpwebwo...@gmail.com> wrote: > > 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 <http://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:329406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
