Not at all...a simple app using simple queries should be easily ported to SQL Server...sure there are slight SQL differences but nothing major - if it were the other way then major headaches....You will probably see that the majority of apps using Access are limited to SELECT, UPDATE, INSERT and DELETE statements - not problem their. You can expect to be using a proper enterprise level db ith SQL Server.....you will inherit all the necessary benefits (and some say curses) of it but all in all a good move....if you can afford it.
NOTE: Yes I do know quite a bit about SQL Server. I certainly didn't study the Certs for bugger all.... -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 01 July 2004 13:56 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL compared to Access backend Really Neil.... from your other posts I got the impression you knew quite a bit about SQL Server... Has someone else been telling you the answers ? > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 01 July 2004 08:12 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] SQL compared to Access backend > > You really wont find much difference...it should work out of > the box...you may find that some double quotes may freak in > SQL2K but all in all it really should be a simple transition. > > > > -----Original Message----- > From: Jolly Green Giant [mailto:[EMAIL PROTECTED] > Sent: 01 July 2004 01:40 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] SQL compared to Access backend > > So how different is your code when your backend is SQL Server > rather than Access? I've worked in Access for 4 years. What > can I expect to be different if I want to work in SQL? Most > simple queries will stay the same, won't they? > > I know some functions may change, but what else? > > Thanks! > > David /jgg > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > This e-mail is from Reed Exhibitions (Oriel House, 26 The > Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a > division of Reed Business, Registered in England, Number > 678540. It contains information which is confidential and > may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended > recipient(s) please note that any form of distribution, > copying or use of this communication or the information in it > is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the > sender or call our switchboard on +44 (0) 20 89107910. The > opinions expressed within this communication are not > necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.com > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
