Back it up using enterprise manager and take it home If your at home or office, you can still connect to the MSDE server using the client tools and you can still running a dts package to transfer the data your your other server (so i am told) and you can set up a VPN over a secure network to make the connection.
Either that or export the data into an access db, zip it up, take it home and restore it. Only other option is forget about the server and buy a fold out sofa bed and camp until the project has finished:P Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Beattie, Barry Sent: Tuesday, June 24, 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/ --- 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/
