Option C sounds pretty good. But you could also create scripts that will recreate the complete db for you at home. You create scripts by right clicking the db in question and select "Generate SQL Script" then choose the appropriate option and voila, there you have a nice text file that will create the db for you at home. And when ready you do the same from home to work I guess.... However, this will not populate the db with data, you will need to write scripts for that as well. That's why option C sounds like the best option. Replication would have been nice, but sounds like that's not an option with security etc..
Taco -----Original Message----- From: Beattie, Barry [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 June 2003 1:51 PM To: CFAussie Mailing List Subject: [cfaussie] RE: <CFQUERY > SQL as a string command >> For those of you who havent heard, Microsoft have a product called MSDE and a cute little beastie it is too... with one drawback for me at work... you can't easily stick it on a floppy to take home to work on it. so here's a question: how do people handle SQLServer/MSDE in changing deveopment environments? eg: you're a student working on a project for assessment. You think you can talk your trainer into installing SQLServer onto a test server at the training organisation. You want to be able to work on the database at home (esp over the hollidays) and you're prepared to install MSDE at home. how do you take the database home (schema + sample data) to work on it and bring back the latest version to update the origional? do you a) ask for PPTP (Point-to-Point Tunneling Protocol) access to the testing server db ("NO WAY" says sysadmin) b) use DTS to copy the database from RTO to home (again thru the firewall - "NO WAY") c) detach the database, burn the MDF and LDF files to CD and re-attach at home (it has to be a CD because the files are so FAT!) c) use magic (this ain't Hogwarts School of magic...) d) give up and either use MSAccess or even MySQL with it's the export features e) use a different method that's perfect for this scenarion which is...(fill in here)... all answers go in the running to win a genuine Australian 2 cent piece made in pure copper alloy... cheers barry.b -----Original Message----- From: Jon Hart [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 June 2003 9:21 AM To: CFAussie Mailing List Subject: [cfaussie] RE: <CFQUERY > SQL as a string command > Ah, the luxury of having a real RDBMS to play with! > > I agree, doing some/lots of the processing (with optional input parameters) within the > database is ideal but I'm having to resort to multiple SP's with <CFIF> when dealing with > JET/MSAccess. For those of you who havent heard, Microsoft have a product called MSDE ( Microsoft Database Engine ). It is the core engine from SQL Server 2000, and is included with many microsoft products. The licensing isnt onerous ( if you bought something that has it, then you have a distribution license ). It includes Enterprise Manager, and as far as you need to be concerned, it operates just like SQL Server 2000. It has a few limitations, 2gb max DB size, only 16 instances per server, only 5 concurrent connections ( others are queued ). Basically, if you are using Access for your site back end, then you should look at MSDE. It is really good. The only issue you might have is using it in a shared hosted environment, but the host should offer SQL Server DB's anyway. If you don't have any MS software with it already, search on google for 'web matrix', which is MS's free .Net IDE, and it also has a download for MSDE, also free. The license in that case only allows deployment with Web Matrix apps. But you can use it locally for whatever you want. Its 70mb for MSDE. Jon Hart. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ ---------------------------------------------------------------------------- This email, together with any attachments, is intended for the named recipient(s) only and may contain privileged and confidential information. If received in error, please inform the sender as quickly as possible and delete this email and any copies from your computer system network. If not an intended recipient of this email, you must not copy, distribute or rely upon it and any form of disclosure, modification, distribution and/or publication of this email is prohibited. Unless stated otherwise, this email represents only the views of the sender and not the views of the Queensland Government. ---------------------------------------------------------------------------- --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
