Heres a good article on upgrading differences.
http://www.elementkjournals.com/sql/0001/sql0011.htm
I also found in my code the following differences:
Access SQL Server
Function
Now() GetDate()
You can use #CreateODBCDate(Now())# around the Now() function and it
will work in both Access and SQL Server
datatype
Yes/No Bit
When converted if you use TRUE/FALSE this will throw an error.
Instead use 1/0 to determine if it should be switched on/off.
Also Delete * from Table needs to be changed to Delete from Table.
Declan Maher
Web Applications Developer
Head Office
133-137 Lisburn Road
Belfast
Northern Ireland
BT9 7AG
T: +44 (0) 28 9022 3224
F: +44 (0) 28 9022 3223
E: [EMAIL PROTECTED]
W: biznet-solutions.com
-----Original Message-----
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
Sent: 20 September 2001 07:47
To: CF-Talk
Subject: RE: Moving from Access to SQL server
SQL probably doesn't like "SELECT * FROM TABLE" - you need to be a bit
more specific about what columns you actually require. If your SQL code
is good you should be able to "upsize" to SQL Server without much
problems.
-----Original Message-----
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 20 September 2001 0:26
To: CF-Talk
Subject: RE: Moving from Access to SQL server
Hi
I have a site which I would like to move from Access to SQl server are
there
any things I need to be aware of code wise things like dates perhaps?
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
