Thanks Dave, and thanks Mark. That gives me what i want. I'll make sure i have good backups of the databases, then try it and see what happens.
In this case, I dont think i'm going to get databases bigger than 4GB. It's only for development and I can think of only two cases in the last 5 years where I've had databases approaching that size for development. Production databases yes, but this isnt for production. And I can confirm that SQLServer2005 will allow you to connect databases on removable drives. I was trying it last week, when I was thinking about how i was going to do this. I had the same thought as you, Dave, so I put a few databases on a removable drive including my little intranet, connected them, and there had been no database errors on those CF Datasources in a day of use. A bit of a surprise really, since in a production environment it wouldn't be a good idea. I would have thought Microsoft would have prevented it happening in the first place. I suppose conceptually it's no different to connecting a server to a database file on a network drive. I might even end up using a USB Key instead of a removable drive! Thanks for your advice. 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 On Tue, Jan 5, 2010 at 1:16 PM, Dave Watts <dwa...@figleaf.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. > > Honestly, I don't know if SQL Server will let you do this. I suspect > it might not, as Windows can detect removable drives. > >> 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? > > Yes, you can use database files created by one with the other, > although there may be some limitations if you use certain features in > SQL Server 2005 when you create the database files (such as the > ability to create databases larger than 4GB - that's not supported by > Express). > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.c ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:329407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
