ooh there's some interesting reading there.. tell ya what though... if I could afford Oracle (and had purchased said database) why would I ever want to go to MSSQL???? I notice they give reasons you might move from MySQL but none for Oracle... hmm
On that note, I'd be very interested to hear how this goes Brian - Have been tempted by the Open Source speed demon in the past but haven't looked into it as the application we were developing at the time "needed" a few features that weren't there at the time (subqueries left over from previous developers and no budget to rewrite...) Good luck! - J > -----Original Message----- > From: Ryan Sabir [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 26, 2004 9:13 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Dealing with different SQL servers? > > > Hey there.. > > There is a Microsoft article on the task.. of course it's all about > going the other way.. but maybe you could read it backwards... > > <http://www.microsoft.com/technet/treeview/default.asp?url=/te chnet/prodtechnol/sql/deploy/upgrdmigrate/mysql.a> sp> > > Also, with the testing the type of database... you could run a query > that you know will work in one and not the other, and catch the error > in a CFTRY, then set a server (or session if you have to) variable > that tells your app what database its connected to. > > bye! > > > > > Thursday, February 26, 2004, 9:01:32 AM, you wrote: > > BG> Hi all, > > BG> Last night I was attempting to migrate from databases > from MSSQL server > BG> to MySQL. > > BG> Migrating the data was easy, but a lot of my queries > don't work anymore > BG> (I've only ever used MSSQL in the past), could people > point me to any > BG> good sites that have examples of query differences please. > > BG> Also is there a way in CF to inspect what type of server > the database > BG> is on so you can use the appropriate query from within a cfif for > BG> example? > > BG> cheers > > BG> Brian > > BG> --- > BG> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > BG> To unsubscribe send a blank email to > [EMAIL PROTECTED] > > BG> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > BG> http://www.mxdu.com/ + 24-25 February, 2004 > > > ----------------------- > Ryan Sabir > Newgency Pty Ltd > 2a Broughton St > Paddington 2021 > Sydney, Australia > Ph (02) 9331 2133 > Fax (02) 9331 5199 > Mobile: 0411 512 454 > http://www.newgency.com/index.cfm?referer=rysig > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
