As I understand it (and I'm no MS Licensing Expert), the only legal solution
is to purchase a per-processor license of Microsoft SQL Server 2000. If you
have a very limited number of users, you can purchase a per-user license,
but ColdFusion by itself is not considered one user, rather, you have to
account for individual end users.
I don't know the details of the developer edition, but I doubt it's legal on
a production server.
Again, if anyone knows otherwise, please speak up :).
As far as converting from an Access DB, yes, SQL Server comes with a very
thorough upsizing wizard that walks you through the process. It converts
everything except (I think) relationships, which they still haven't ironed
out.
Enterprise Manager is the GUI front-end. If you understand Access, you
shouldn't have a problem picking it up.
Hope this helps
Norman Elton
-----Original Message-----
From: kaigler [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 9:29 AM
To: CF-Server
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
