The production server needs to be running the Standard Edition. You cannot
legally run a public web site with a copy of the developers edition. The dev
edition is for development only.
You can however maintain, and connect to the production server with your
copy of developers edition.
Functionally there is not really a difference between the two that I have
seen, it's just a legal issue.
Bud Schneehagen went through a lot of hoops with MS a couple of months back
to find out the legality of how sql server should be licensed with CF a few
months back on cf-talk. Check the archives for the details.
Upsizing to SQL is very easy, the only thing to watch out for is unless you
specify it, SQL Server will not import primary keys. Go through each of your
tables and make sure the pk fields are still pk's...
jon
----- Original Message -----
From: "kaigler" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 9:28 AM
Subject: changing database software
> I have a question about how databases work with cold fusion.
>
> If I create an MS SQL database and set up the odbc connection through cold
> fusion can I as one person maintain this database through a copy of 'SQL
> SERVER 2000 DEVELOPER ED'? Or do I need a copy of 'MSFT SQL Server 2000
> Standard Edition'?
>
> Do I have to have a copy of 'SQL Server 2000 Standard Edition 1-Processor
> License' running on my server.
>
> Since I am not going to be interfacing with this other then through Cold
> Fusion my guess is I would only need the developer's license.
>
> Last question(s), I understand that msft sql server has an interface like
> access. is this correct? any suggestions on transferring my database to
> sql server?
>
> thanks,
> kaigler
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
