Dear Kaigler,
While I have no experience with SQL Server 2000, I have merged databases
from other sources into SQL7. I generally found the major problem to be the
formatting of the fields to meet the field type specific to SQL 7 to be the
major drawback. Even moving the file into Access as a prelude to moving it
to SQL and attempting to format it there is not the best tactic. Generally,
I moved it first to Excel and then formatted the fields there. One thing to
watch out for are the date/time formats. If you want to move a field into
SQL that will require a time stamp on the date, you will have to add a
portion of a day to the date in order to move it into SQL. Make sure you
understand the definition of the field type so you can format the
information to be moved into SQL in a way that it will accept it.
I hope this is helpful. I'm no expert but I have faced and overcome some of
the problems.
John T. Passannante
[EMAIL PROTECTED]
-----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
