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
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 MYSQL
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 any data,
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
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 as this.
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 away from
MS SQL.
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 affordable
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 plenty of reasons to migrate
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 forget
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
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
using a
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 wants to get
-
From: Denny Valliant [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
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 of the situations I've
seen like
-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
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 regularity
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.
soap box
This is the #1 reason why I try to stay informed on what features are
proprietary and
+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
ColdFusion Lead
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.
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. We
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
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 do need
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've
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 tend
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
clustering?
B.
- Original Message -
From: Munson, Jacob [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
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
staggering cost of MS SQL Server
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
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
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.
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
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 mySql
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
blah
blah
- Original Message -
From: Matt Robertson [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
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
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 tried
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
Thanks alot Jon!! I will check it out.
Regards,
Doug B.
- Original Message -
From: Jon Clausen [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Saturday, October 28, 2006 2:52 PM
Subject: Re: Converting from SQL to mySql
Doug,
I just migrated most of my databases
35 matches
Mail list logo