John's got a point... Sometimes the formatting does go slightly awry,
probably moreso if you're coming from a non-microsoft database...
I just noticed that the latest issue of the ColdFusion Developers Journal
has an article "Upgrading Access to SQL Server". It may be worth a look if
this applies to you. The local Barnes & Noble seems to stock them, so I try
to peruse the latest issue whenever I'm in there. You may be able to find
the article on their website as well.
The article does have a handy little grid outlining the (few) differences
between Access's SQL and SQL Server's SQL. For instance, in Access, you use
Now() to retrieve the current date/time. In SQL Server, you must use
GetDate()... There are a handful of others, but their simple to
find/replace.
Norman Elton
-----Original Message-----
From: John T. Passannante [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:02 AM
To: CF-Server
Subject: RE: changing database software
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
