> I am wondering how difficult it might be to migrate over to mySql from
> SQL2000? Is this a daunting task? Any assistance would be much
> appreciated. I would especially love to hear from someone who has done
> this.
>
>
>
> Regards,
>
>
> Doug B.
Here is a tool to convert mssql to MYSQ
> I am wondering how difficult it might be to migrate over to mySql from
> SQL2000? Is this a daunting task? Any assistance would be much
> appreciated. I would especially love to hear from someone who has done
> this.
>
>
>
> Regards,
>
>
> Doug B.
Here is a tool to convert
[url=http://
> > The value proposition of CF is that it pays for itself with shorter
> > development and maintenance times. If that's not true for
> > you, you shouldn't
> > buy it no matter what the price is. If it is true for you,
> > the price is
> > irrelevant. As enterprise products go, CF is dirt cheap
> I am wondering how difficult it might be to migrate over to mySql from
> SQL2000? Is this a daunting task? Any assistance would be much
> appreciated. I would especially love to hear from someone who has done
> this.
>
>
>
> Regards,
>
>
> Doug B.
I use data loader for migrating almost
On 10/30/06, Dave Watts <[EMAIL PROTECTED]> wrote:
> > I honestly believe that if companies like the yahoo and
> > google, who use mySql to run portions of their websites,
> > figure to prove that a whopping $20,000 licence for MS
> > or Oracle just is not worth it.
>
> Things just aren't as simple
-
From: "Denny Valliant" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, October 31, 2006 6:15 PM
Subject: Re: Converting from SQL to mySql
> On 10/31/06, Dave Watts <[EMAIL PROTECTED]> wrote:
>
>> > That's, as you say, presumption. Most
On 10/31/06, Dave Watts <[EMAIL PROTECTED]> wrote:
> > That's, as you say, presumption. Most of the situations I've
> > seen like this are from folks who've been using third-party
> > hosting for a while. It was the third-party host that was
> > using a Windows environment, and the client want
> > If you're currently running MS SQL Server, you presumably
> > already have a Windows infrastructure.
>
> That's, as you say, presumption. Most of the situations I've
> seen like this are from folks who've been using third-party
> hosting for a while. It was the third-party host that was
> u
> Don't forget about people that sell software. Even though
> I'm a CF developer, and I love it, if I wanted to make a web
> based product that would go to small/medium businesses, I'd
> hate to have to tell them, "My product costs $150, but I'm
> charging you a $1450 because it's built on Col
> The value proposition of CF is that it pays for itself with shorter
> development and maintenance times. If that's not true for
> you, you shouldn't
> buy it no matter what the price is. If it is true for you,
> the price is
> irrelevant. As enterprise products go, CF is dirt cheap.
Don't forg
Charlie Griefer wrote:
> On 10/31/06, Jordan Michaels <[EMAIL PROTECTED]> wrote:
>
>>Dave Watts wrote:
>>
>For the record, I'm not saying there aren't any good reasons
>to migrate from MS SQL Server to MySQL, just that price isn't
>necessarily one of them.
Dave, I can think of
On 10/31/06, Jordan Michaels <[EMAIL PROTECTED]> wrote:
> Dave Watts wrote:
> >>>For the record, I'm not saying there aren't any good reasons
> >>>to migrate from MS SQL Server to MySQL, just that price isn't
> >>>necessarily one of them.
> >>
> >>Dave, I can think of plenty of reasons to migrate a
Dave Watts wrote:
>>>For the record, I'm not saying there aren't any good reasons
>>>to migrate from MS SQL Server to MySQL, just that price isn't
>>>necessarily one of them.
>>
>>Dave, I can think of plenty of reasons to migrate away from
>>MS SQL. How about platform independence? How about aff
On 10/28/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> I do not think it liked the @
Sorry if my original post was misleading but when I move my own code
from one platform to another all I do is copy the table structure and
data. I use zero db-specific features so as to be able to do that.
Not some
> I honestly believe that if companies like the yahoo and
> google, who use mySql to run portions of their websites,
> figure to prove that a whopping $20,000 licence for MS
> or Oracle just is not worth it.
Things just aren't as simple as this. Companies like these would pay far
more than $20K
Doug B.
- Original Message -
From: "Munson, Jacob" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, October 30, 2006 4:42 PM
Subject: RE: Converting from SQL to mySql
>> Oh yeah, and on the costs issue, don't forget that in addition to the
&
> > For the record, I'm not saying there aren't any good reasons
> > to migrate from MS SQL Server to MySQL, just that price isn't
> > necessarily one of them.
>
> Dave, I can think of plenty of reasons to migrate away from
> MS SQL. How about platform independence? How about affordable
> clust
> Oh yeah, and on the costs issue, don't forget that in addition to the
> staggering cost of MS SQL Server itself, you are also forced to run it
> on a MS OS - which costs another very shiny penny. Cost is certainly a
> factor - and usually the one board members care about the most.
Strangely, I t
> If you don't need SQL Server Enterprise or Standard functionality, SQL
> Server 2005 Express is free. If you do need the sort of
> functionality found
> in Enterprise (as opposed to Standard), a lot of it doesn't
> exist in MySQL
> to the best of my knowledge.
Slightly OT, but here at work we'
Dave Watts wrote:
>>What about if you're using an outdated version of MSSQL, and
>>you'd have to pay $20,000 to upgrade to 2005? I'd be
>>inclined to look around for cheaper DBs.
>
>
> If you don't need SQL Server Enterprise or Standard functionality, SQL
> Server 2005 Express is free. If you
> What about if you're using an outdated version of MSSQL, and
> you'd have to pay $20,000 to upgrade to 2005? I'd be
> inclined to look around for cheaper DBs.
If you don't need SQL Server Enterprise or Standard functionality, SQL
Server 2005 Express is free. If you do need the sort of functio
Doug Brown wrote:
> I am wondering how difficult it might be to migrate over to mySql from
> SQL2000? Is this a daunting task? Any assistance would be much appreciated. I
> would especially love to hear from someone who has done this.
>
>
I did this a year ago with a very large application. W
> I'm a *big* fan of MySQL, on any platform, but license cost savings
> alone shouldn't drive you to the conversion.
What about if you're using an outdated version of MSSQL, and you'd have
to pay $20,000 to upgrade to 2005? I'd be inclined to look around for
cheaper DBs.
As far as community vs
+1 for Navicat. :)
Christine Davis wrote:
> I recently made the same switch using www.navicat.com I just connected
> to my SQL server and copied the tables and data to the mySQL server,
> quick and painless. I really like Navicat for managing mySQL.
>
> Thanks!
> Christine Davis
> ColdFusio
> Yeah I ran into the same thing when I tried convertin a sql
> db to mysql. Had lotsa queries that bombed out. Speakin of
> queries, I think dave might have some good tips on mysql. he
> uses it alot.
This is the #1 reason why I try to stay informed on what features are
proprietary and what
On 10/28/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> I am wondering how difficult it might be to migrate over to mySql from
> SQL2000? Is this a daunting task? Any assistance would be much appreciated. I
> would especially love to hear from someone who has done this.
I do this with some regulari
-748-8044 ext 4703
[EMAIL PROTECTED]
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 28, 2006 4:17 PM
To: CF-Talk
Subject: Re: Converting from SQL to mySql
Thanks alot Jon!! I will check it out.
Regards,
Doug B.
- Original Message -
From
Thanks alot Jon!! I will check it out.
Regards,
Doug B.
- Original Message -
From: "Jon Clausen" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Saturday, October 28, 2006 2:52 PM
Subject: Re: Converting from SQL to mySql
> Doug,
>
> I just migrated
Doug,
I just migrated most of my databases from MSSQL to MySQL 5 a few
weeks ago.The Intelligent Converter Toolkit ( http://www.convert-
in.com/sqlkit.htm ) was a lifesaver and made it pretty painless
overall. It did a great job of converting the datatypes over and
transferring the
>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 @
Yeah I ran into the same thing when I tr
blah
blah
- Original Message -
From: "Matt Robertson" <[EMAIL PROTECTED]>
To: "CF-Talk"
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.
>
>
Backwards? I do not consider going from $20,000 to $0 a backwards move.
Thanks for the help!
Doug B.
- Original Message -
From: "Matt Quackenbush" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Saturday, October 28, 2006 11:10 AM
Subject: RE: Converting from
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
Why would you want to go backwards? :-)
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 28, 2006 12:01 PM
To: CF-Talk
Subject: Converting from SQL to mySql
I am wondering how difficult it might be to migrate over to mySql from
SQL2000? Is this a
34 matches
Mail list logo