Hi Everyone
I am now familiar with connecting with MySQL using Visual Basic 6 and ADO. I am
about to start a new project which must connect to a customer's MS SQL Server
2005 installation.
How safe/unsafe is my assumption that as far as SQL strings and ADO connections
are concerned 'if it
Most of the
basic statements should work fine on both, but here are several points
you should keep in mind:
- SQL Server doesn't support LIMIT clause;
- Don't use quotes for numerical values as it works on MySQL only;
- In GROUP BY clause, list all not aggregated columns you are selecting;
- Use
What about
DROP TABLE IF EXISTS TableName
and
CREATE TABLE NewTableName...
and
ALTER TABLE TableName ADD COLUMN DeliveryNoteNumber INT NOT NULL DEFAULT 0
Thanks
Jonathan Trahair
Most of the basic statements should work fine on both, but here are several
points you should keep in mind:
-
SQL Server doesn't support the IF EXISTS clause.
There are also differences in data types.
On 1/23/08, J Trahair [EMAIL PROTECTED] wrote:
What about
DROP TABLE IF EXISTS TableName
and
CREATE TABLE NewTableName...
and
ALTER TABLE TableName ADD COLUMN DeliveryNoteNumber INT NOT NULL DEFAULT
Hello,
This is a long post, my apologies.
I have been working on migrating a database from MS SQL to MySQL for about 1
month now and am at a point where I can start running some tests to see how
they compare. I'll provide a little background to help you out.
The MS SQL database is 120million
Hi Chris,
Chris Fossenier wrote:
This is a long post, my apologies.
Speaking for myself, I found the detail most helpful. Thanks!
See response at bottom.
...snip...
QUERY1
~~~
Indexed Fields (link, phone_pander,state, exact_age, estimated_age, phone,
first, last, address)
MS SQL QUERY
23, 2004 11:42 AM
To: Chris Fossenier; [EMAIL PROTECTED]
Subject: Re: MySQL versus MS SQL
Hi Chris,
Chris Fossenier wrote:
This is a long post, my apologies.
Speaking for myself, I found the detail most helpful. Thanks!
See response at bottom.
...snip...
QUERY1
~~~
Indexed Fields
you do with the suggestion in this mail is you responsibillity even
if your system will crash :)
-Original Message-
From: Chris Fossenier [mailto:[EMAIL PROTECTED]
Sent: maandag 23 februari 2004 18:16
To: [EMAIL PROTECTED]
Subject: MySQL versus MS SQL
Hello,
This is a long post, my
Chris Fossenier writes:
... Query 1
a1.phone_pander_flag 'Y'
AND state.state = 'PA'
AND ( h1.homeowner = 'Y'
OR h2.probable_homeowner IN ('8','9')
OR h2.homeowner_probability_model BETWEEN '080' AND '102' )
AND ( p1c.exact_age BETWEEN '40' AND '60'
OR estimated_age BETWEEN '40'
Chris,
We run a large data warehouse with tables similar to yours. We basically gave up on
indexing and the overhead involved and just tablescan. The key is to partition the
data using a concept called Merge Tables. However, since we currently use Oracle,
eager to migrate to MySQL - I don't
KEVIN ZEMBOWER wrote:
The organization hired an outside consultant to
evaluate which SQL engine to go with. This is
what he sent to us:
...
SQL Server 2000 is a complete Relational Database
Management System (RDBMS) that also includes integrated
analysis functionality for OLAP and data mining.
comparison of MySQL and MS SQL Server 2000?
2. Is this up to date with the current status of MySQL?
3. Would the deficiencies pointed out in MySQL, if true, apply to the type of work we
envision? Granted, I haven't given you all much information about what we hope to do
with an SQL engine, but I don't
for lots of readers
and concurrent
writers.
My questions are:
1. Is this a fair comparison of MySQL and MS SQL Server 2000?
Fairly fair :-)
2. Is this up to date with the current status of MySQL?
Triggers, views and Stored Procedures are expected to be included in MySQL
5.
The next version
Martijn, thank you very much for your analysis. I hope others will continue to join in.
With regard to your point quoted below, are you referring to PostgreSQL, and would
that be a
stronger competitor to MS SQL Server 2000 than either the current version of MySQL or
MySQL 5?
Thanks, again, for
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will continue to join in.
So do I :-)
With regard to your point quoted below, are you referring to PostgreSQL,
and would that be a
stronger competitor to MS SQL Server 2000 than either the current version
of MySQL or
I have not work with it but postgres is supposed to work great in
/BSD/Linux/Unix/solaris environment
Which platform are you using?
:-)
Nestor A. Florez
Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM
Hi Kevin,
Martijn, thank you very much for your analysis.
I hope others will
this himself, or if it came
from somewhere. It could be Microsoft advertizement, for all I know.
Most of the terms aren't familiar to me, like sub-queries or
referential integrity. I feel out of my depth evaluating this
comparison.
My questions are:
1. Is this a fair comparison of MySQL and MS SQL
Nestor, thanks for your question.
The platform will actually be dictated by the SQL engine, not the
other way around, which is more typically the case. If we go with
MS SQL Server, we'll build a separate host, NT I would guess, to
host it. I'm only responsible for Unix and Linux boxes here, so
that do
very nicely without them. Why are you different?
John Griffin
-Original Message-
From: KEVIN ZEMBOWER [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 1:53 PM
To: [EMAIL PROTECTED]
Subject: Re: Need help comparing MySQL to MS SQL Server
Nestor, thanks for your question
kevin,
i tend to think the consultant really just read something that microsoft
sent him. it doesn't sound like he's qualified to suggest one database
or another.
We've been usinf mysql for a year now. We use InnoDB tables, which give
us primary key/foreign key constraints and transactions.
Will be any problem if I install MySQL 4.0.15 for Win on the Server that
already has MS SQL 2K under W2K Server?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Will be any problem if I install MySQL 4.0.15 for Win on the Server that
already has MS SQL 2K under W2K Server?
Except that they may be battling for resources: no.
You can also adjust the MS SQL 2K settings to have a maximum memory
and CPU usage.
With regards,
Martijn Tonies
Database
Look into a product called SQLPorter.
http://www.realsoftstudio.com
I used it once for a MySQL to MSSQL migration project, but you could go
in the other direction. If I remember correctly, I think it includes a
scheduling feature.
-bill
On Tue, Jan 21, 2003 at 01:15:01PM -, John Lodge
Hello all,
I wonder if anyone has set up a MySql database to mirror one running on MS
Sql Server. Although this sounds like an odd requirement, I have
a project where this would be extremely useful. Can anyone give me any
suggestions as to where to find out more information on this subject.
I
problems having MS SQL and
MySQL running on the same machine.
My personal opinion is no - but I need to find some info to reassure the
network guys:)
Any information on this subject will be greatly appreciated.
Regards,
David
Should be fine. I never ran both at high load together
problems having MS SQL and
MySQL running on the same machine.
My personal opinion is no - but I need to find some info to reassure the
network guys:)
Any information on this subject will be greatly appreciated.
Regards,
David
Should be fine. I never ran both at high load together
Hi there,
I will shortly be installing a MySQL server at my place of work, the box I
will be installing it on currently has MS SQL server running as well. (I
believe its a wintel box).
Anyway, I am wondering if there are any known problems having MS SQL and
MySQL running on the same machine.
My
: Will French [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 10:00 PM
To: [EMAIL PROTECTED]; Pavel Hant; [EMAIL PROTECTED]
Subject: RE: Migration to mysql from MS SQL Server
venu: If you can make use of MS Access and ODBC in the middle layer in
venu: the conversion,
venu: from MSSQL
Harpreet writes:
Can we create a php page that will use mssql_connect to connect to ms sql
server get the data and then use mysql_connect and connect to mysql server
and populate the table.
Is this possible.
Yes, but only if you don't include 8 kilobytes worth of
redundant irrelevance
: Migration to mysql from MS SQL Server
Harpreet writes:
Can we create a php page that will use mssql_connect to connect
to ms sql
server get the data and then use mysql_connect and connect to
mysql server
and populate the table.
Is this possible.
Yes, but only if you don't include 8
Ravi Raman writes:
Hi.
I got the impression Harpreet was looking for some advice/experiences from
someone who had ported a database in this way. He most likely was not
looking for a snide, essentially one-word reply.
Well, I could've said that I've done similar things for 2 different
for mssql installed (please correct me if I'm wrong).
Cheers,
Fred Woolsey
-Original Message-
From: Carl Troein [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 3:37 PM
To: [EMAIL PROTECTED]
Subject: My attitude (Was:Migration to mysql from MS SQL Server)
Ravi Raman writes:
Hi
I have participated on several groups before and this was the first time i
received a comment like this. I didnt wanna bother replying to it as i know
people r different and i am glad we have this delete button that i rely on
in such cases :)
Yes i was here for an advice and thank you Mr. Ravi
Hi everybody,
I am trying to migrate a database from MS SQL Server 2000 to mysql. Does
anybody know any source of information on this matter, or can anybody share
his/her own experience of such a migration? Suggestions?
Any help would be appreciated.
Thanks,
Pavel
To: [EMAIL PROTECTED]
Cc: Pavel Hant
Subject: Migration to mysql from MS SQL Server
Hi everybody,
I am trying to migrate a database from MS SQL Server 2000 to mysql. Does
anybody know any source of information on this matter, or can
anybody share
his/her own experience of such a migration
Hi !!!
-Original Message-
From: Will French [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 12:28 PM
To: Pavel Hant; [EMAIL PROTECTED]
Subject: RE: Migration to mysql from MS SQL Server
I just did this with a rather large database. Here are the steps that I
: Wednesday, October 03, 2001 4:00 PM
To: [EMAIL PROTECTED]; Pavel Hant; [EMAIL PROTECTED]
Subject: RE: Migration to mysql from MS SQL Server
Hi !!!
-Original Message-
From: Will French [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 12:28 PM
To: Pavel Hant; [EMAIL
, July 18, 2001 7:51 PM
Subject: MySQL or MS SQL?
I'm currently writing proposals for a customer who want to hire our little
programming team for creating corporate information system, wich includes
huge database with number of records between 1-10 millions (incl. blobs -
pictures). Expected
database, blobs etc, MS SQL vs. MySQL, your opinion?
Many thanks in advance,
Alexander
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
scares the crap out of me when it comes to security.
Anywho, probably way beyond what you wanted to know,
Chris
-Original Message-
From: Alexander Chernienko [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 11:51 AM
To: [EMAIL PROTECTED]
Subject: MySQL or MS SQL?
Hi all,
I'm
On Wed, Jul 18, 2001 at 12:38:29PM -0600, Chris Cameron wrote:
I think people who use proprietary software systems are just
accustomed to being gouged by ridiculous software costs.
Not to mention that it also costs us more to accomodate them.
Basically, distorting the argument a little, you
I like MySQL, and I'm fairly new at it, but if I were to need to store and
retrieve tens of Gb's, I would want an IBM AS/400. Base configurations are
quite reliable, and you can easily add RAID and other types of redundant
support, up to and including redundant machines. I work with numerous
a nominal
amount, it puts in to the mind of the customer that nothing comes for free.
Regards
Quentin
-Original Message-
From: Michael Bacarella [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 19 July 2001 7:47 a.m.
To: Chris Cameron
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL or MS SQL?
On Wed
Hey guys,
Most of the accounts I have read about MySQL was that it was one of the fastest
databases around. Now, for development purposes I created a FreeBSD system with JUST
MySQL (no other major processes). Then I created a separate Windows 2000 ASP server to
server as our development
On Tue, Mar 27, 2001 at 02:12:36PM -0800, Steve Quezadas wrote:
Anyways, a period of time elapsed and we decided to move to MS-SQL
server for feature reasons, and when we had the MS-SQL ODBC driver
point to the newly created MS-SQL server (roughly same specs), it
was like 50% faster! What
: Tuesday, March 27, 2001 4:18 PM
To: [EMAIL PROTECTED]; Steve Quezadas
Subject: Re: MySQL vs MS-SQL performance
Steve,
I also experienced the same results you did until I realized that
the MS-SQL connection was using pooled connections and my
use of MySQL wasn't. After I started using persistent
46 matches
Mail list logo