>> 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/
