> I am curious as to which 'good reasons' result in database
> requirements that open source databases can't meet. I can think
> of a few (synchronous multimaster WAN replication, extreme OLTP
> throughput etc.), but none that I would see in 'most systems'.
>
> Jochem
As I've said beforeI...th
I'm coming into this thread late, and I am certainly not trying to
perpetuate the argument. However...
I develop on the Win32 platform and have used both Oracle and MS-SQL
Server (primaril SQL Server). Recently I did a site for a small
non-profit who had a limited budget, so I chose a host that
Bryan Stevenson wrote:
>
> and I never overlook the free options...but most systems I'm involved
> with have higher requirements (either for good reasons or political
> ones)...this is a global system (and not just cause it will be online)
I am curious as to which 'good reasons' result in d
assume thats your problem.
~Dave the disruptor~
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
Sent: Thursday, May 05, 2005 6:09 PM
To: CF-Talk
Subject: Re: import from MySQL to MS SQL
>I don't think you can actually expect to exp
> I've had a modicum of success in the past by exporting to something like
> Excel might understand (using DBtools or somesuch), and then importing
> that
> file into MSSQL using DTS (if neccessary, making row format alterations in
> the exported file first).
just about to try that actuallygo
orted file first).
HTH,
Ian
- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, May 05, 2005 11:06 PM
Subject: Re: import from MySQL to MS SQL
> >I don't think you can actually expect to export from o
Richard Crawford wrote:
>
> Looking back in my own work journal here, I see that I encountered the exact
> same problem once myself; the source table contained null values in a field
> which had a not-null constraint, as well as text data in a numeric-only
> field, and non-boolean values in a b
On Thursday 05 May 2005 15:01, Bryan Stevenson wrote:
> Yeah...but if apply the NOT NULL rrule after...it still shouldn't let you
> if there are NULLs in the data ;-);-) (not that this is the case
> here...straight import from live DB to local MySQL.and off to MS SQL)
I don't see how it's poss
Richard Crawford wrote:
> On Thursday 05 May 2005 14:46, Bryan Stevenson wrote:
>>
>> Because MySQL has allowed NULLS to be entered into NOT NULL fields!!!
>
> That's kinda bizarre. I've never seen that behavior before. Ever.
If you think that is bizare you might find the following
interesti
>I don't think you can actually expect to export from one database vender to
>another and not expect to have to tweak a few things.
> Do a simple export/import from access to mysql and see what happens, it
> ain't disney nor pixel fairy dust, it won't be "exact" or "perfect" nor
> should you exp
> In your case, if better referential integrity then MySQL
> currently offers is in the list of requirements, you should
> remove MySQL. If you have 'vendor must have 24/7 support in 12
> countries/4 languages' in your list you can pretty much scrape
> everything but DB2, Oracle and MS SQL Server.
> Well, actually, yes I have, but only when the data was imported into the
> MySQL
> tables from another database, and the not null rule was applied to the
> field
> *after* the data was already put into place. Sounds like you've inherited
> a
> strange, strange setup.
Yeah...but if apply the
ect" nor should you
expect it to be.
From: Richard Crawford <[EMAIL PROTECTED]>
Sent: Thursday, May 05, 2005 5:50 PM
To: CF-Talk
Subject: Re: import from MySQL to MS SQL
On Thursday 05 May 2005 14:46, Bryan Stevenson wrote:
> Here's
Bryan Stevenson wrote:
>>
>> What sort of support do you mean? Are you afraid it will suddenly
>> stop working?
>
> As has been said lately on listyou get what you pay for... Crap I said
> I wouldn't get into this...just wanted a little help and I get jumped o by
> the open source police ;
On Thursday 05 May 2005 14:46, Bryan Stevenson wrote:
> Here's some justification for all you MySQL fans
>
> Ya wanna know why 21 tables are not importing??...huh...do ya??
>
> Because MySQL has allowed NULLS to be entered into NOT NULL fields!!!
>
> MySQL can kiss my.
>
> Free = data corruptio
Here's some justification for all you MySQL fans
Ya wanna know why 21 tables are not importing??...huh...do ya??
Because MySQL has allowed NULLS to be entered into NOT NULL fields!!!
MySQL can kiss my.
Free = data corruption
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Devel
On Thursday 05 May 2005 10:53, Bryan Stevenson wrote:
> LMAO...I was waiting for this one...umm Richard...it's because MySQL no
> matter what anybody says is not an enterprise level DB
> (yet)refrerential integrity comes to mind ;-);-)
Heh. Well, note that I didn't go into *why* it boggled my
You got it Cliff...long live CF!!
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
~~
> So why not move straight from MySQL to Oracle. Or in fact, why
> not start with Oracle in the first place?
Read my posts!! ;-) VC money = Oracleuntil then is MS SQL to get the
product finished
> What sort of support do you mean? Are you afraid it will suddenly
> stop working?
As has bee
No problem :) I used MySQL with CF as I was getting started in app
development but outgrew its feature set after a while. One thing I
will say about PgSQL is that its syntax is much more Oracle-like
(read: ANSI compliant) than MySQL. All that aside, no matter what
database you're using, at least
Bryan Stevenson wrote:
>> How about PostgreSQL then?
>
> How 'bout it ;-)
It has all the features you mention.
> Moving to Oracle after SQL Server as already posted ;-)
So why not move straight from MySQL to Oracle. Or in fact, why
not start with Oracle in the first place?
> I'm just not a
Hey Cliff,
Thanks for the heads upwhile I may not prefer the "free" stuffI do
try and keep up with product advancement (like MySQL 5 is strarting to get
there)they'll be a time where I'm sure I'll be a MySQL advocate...but
not yet ;-)
Cheers
Bryan Stevenson B.Comm.
VP & Director o
On 5/5/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> I'm just not a free kind of guyin my experience free means "free until
> you have to support it...then it costs more to fix issues than the tool ya
> would have paid for.
>
There is commercial support available for PostgreSQL:
http://
> How about PostgreSQL then?
How 'bout it ;-)
Moving to Oracle after SQL Server as already posted ;-)
I'm just not a free kind of guyin my experience free means "free until
you have to support it...then it costs more to fix issues than the tool ya
would have paid for.
Kinda like CFyou
> Though I really thought that the meat of my earlier post lay in my joke
> about
> Larry Ellison.
hehe...well let's all be thankful that Larry has nothing to do with the
pricing of CFMX ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone:
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
>
> with MySQL...my feeling is that you need to "add" all sorts
> of things that come standard in MS SQL and Oracle...hell...
> even Access
How about PostgreSQL then?
--
Damien McKenna - Web Developer - [EMAIL PROT
On Thursday 05 May 2005 13:09, Bryan Stevenson wrote:
> > Personally, even for the biggest sites I've run, I've never needed a
> > full-fledged enterprise level database. If I did, though, I'd probably
> > go with Oracle or some other vendor
>
> and that's exactly where we're headingbut the VC
> Personally, even for the biggest sites I've run, I've never needed a
> full-fledged enterprise level database. If I did, though, I'd probably go
> with Oracle or some other vendor
and that's exactly where we're headingbut the VC has to come in first
;-)
with MySQL...my feeling is that you
On Thursday 05 May 2005 10:53, Bryan Stevenson wrote:
> LMAO...I was waiting for this one...umm Richard...it's because MySQL no
> matter what anybody says is not an enterprise level DB
> (yet)refrerential integrity comes to mind ;-);-)
Heh. Well, note that I didn't go into *why* it boggled my
>I'm not sure ODBC drivers exist for MySQL. Although I work with both
>platforms, I've never had a need to connect a SQL Server database to a MySQL
>database.
As others have suggested, by far the simplest way to do this is to download the
ODBC drivers from the MySQL web site. Install those on
Bryan Stevenson wrote:
>>Or go the other way, export out of MySQL and import into MSSQL instead of
>>pulling in. You should be able to export in many different flavors.
>>
>>
>
>The 30 day eval of the MySQL admin tool I'm using only exports 1 table at a
>time!!so I'll go the ODBC route..
>> If you insist on converting from MySQL to MS SQL Server (a concept which
>> boggles me, to be honest),
>
>LMAO...I was waiting for this one...umm Richard...it's because MySQL no
>matter what anybody says is not an enterprise level DB (yet)refrerential
>integrity comes to mind ;-)
I think
go to the mysql bin directory on the cmd line.
mysqldump -u username -p -d databasename > c:\dumpfile.sql
password:**
Now go look at that file. It's all the creates and inserts you need. I
would assume this would work for you
Bryan Stevenson wrote:
>>Or go the other way, export out of MyS
Thanks Matt...that's sounds like the missing piece (new it would be simple)
;-)
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.
> If you insist on converting from MySQL to MS SQL Server (a concept which
> boggles me, to be honest),
LMAO...I was waiting for this one...umm Richard...it's because MySQL no
matter what anybody says is not an enterprise level DB (yet)refrerential
integrity comes to mind ;-)
Please...lets
Bryan,
CFMX ships with a MySQL driver compatible with MySQL 3.23 - 4.0.x. MySQL 4.1
changed the password algorithm, so the driver doesn't work as-is with 4.1+.
Read this Technote for how setup CFMX with MySQL 4.1:
http://www.macromedia.com/go/6ef0253
Alternately, you can configure MySQL to st
> Or go the other way, export out of MySQL and import into MSSQL instead of
> pulling in. You should be able to export in many different flavors.
The 30 day eval of the MySQL admin tool I'm using only exports 1 table at a
time!!so I'll go the ODBC route...but thanks Connie
Cheers
Bryan Ste
On Thursday 05 May 2005 10:32, Bryan Stevenson wrote:
> > MySQL is not file based like Access. You need to have a copy of
> > MySQL installed and running.
>
> I do JochemMySQL 4.1.11...with an imported copy of the live database
> ;-);-)
>
> As I mentionedI can't figure out how to setup the
You have to download the ODBC drivers from the MySQL web site.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 10:32 AM
To: CF-Talk
Subject: Re: import from MySQL to MS SQL
As I mentionedI can't figure out how to setup the
Or go the other way, export out of MySQL and import into MSSQL instead of
pulling in. You should be able to export in many different flavors.
~|
Find out how CFTicket can increase your company's customer support
efficiency b
Go to the mysql site and download myODBC. Install it and then make
your ODBC connection via the Windows ODBC control panel applet. Once
myODBC is in you'll have a mySQL choice on the dbtype list.
--
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com
~~
> MySQL is not file based like Access. You need to have a copy of
> MySQL installed and running.
I do JochemMySQL 4.1.11...with an imported copy of the live database ;-)
As I mentionedI can't figure out how to setup the ODBC connection to my
local copy of the MySQL DBthere do not see
Bryan Stevenson wrote:
>
> I've taken over a MySQL based project and I need to suck the tables and data
> in MS SQL Server 2000.
>
> I fired up DTS and don't see any options for importing from MySQL (and I'm
> not sure how MySQL stores data...what kind of file extension etc.).
MySQL is not fil
Hey All,
I've taken over a MySQL based project and I need to suck the tables and data in
MS SQL Server 2000.
I fired up DTS and don't see any options for importing from MySQL (and I'm not
sure how MySQL stores data...what kind of file extension etc.).
So...anybody have a few pointers to get me
44 matches
Mail list logo
