Well, it would be moved over from a SQL 2000 DB to mySql 5. So basically would all the query structures work in mySql that were written for SQL 2000? I have seen a few instances where mySql crapped out on things like ... I do not think it liked the @
declare @myid int begin select @myid blah blah blah ----- Original Message ----- From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Saturday, October 28, 2006 11:23 AM Subject: Re: Converting from SQL to mySql >I work in both platforms and go back and forth between them all the time. > > what versions are we talking about? mySQL5 ports right over no > problemo. Date fields used to be an issue in older versions but I > don't recall having any problems recently. > > Get hold of a copy of sqlYog. You can connect to your SQL datasource > via an odbc connection and pull the whole thing right into the SQL > database of your choice. Will take you only a few minutes per table, > not counting the time to actually copy the data. > > -- > [EMAIL PROTECTED] > Janitor, MSB Web Systems > mysecretbase.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
