Workbench provides some migration features and supports SQL Server
http://www.mysql.com/products/workbench/migrate/
On Mon, Jul 14, 2014 at 4:47 PM, Felipe Coutinho
wrote:
> Hello,
>
> I'm a web developer and I'm developing a web application on Rails. I'm
> gonna u
Hello,
I'm a web developer and I'm developing a web application on Rails. I'm
gonna use MySQL at production (I'm using Amazon RDS with MySQL) for this
app. But this app already has a version of it (developed at ASP.NET) at
production using SQL Server. Now I need to migra
>>>> 2012/04/05 02:15 -0700, sam >>>>
I have data file written in SQL Server Compact.I need to Convert it to MySQL.
Does anyone know how to do that?
<<<<<<<<
If it stores in CSV files, you can use that for the data, although to make
MySQL read it
Unfortunately they don't have MySQL Migration Toolkit for Ubuntu
--- On Thu, 4/5/12, Pothanaboyina Trimurthy wrote:
From: Pothanaboyina Trimurthy
Subject: Re: Convert SQL Server Compact data to MySQL
To: "sam"
Date: Thursday, April 5, 2012, 4:56 AM
hello sam
you can convert
Hello,
I have data file written in SQL Server Compact.I need to Convert it to MySQL.
Does anyone know how to do that?
Thank you,
Sam
t
sure if you can set up a continuous or batched replication job towards non-SQL
server tables, it's been too long since I played with it.
I vaguely recall reading something about some tool that might do it, but I
really don't have any idea what it was or where I saw that. Maybe someone else
I'm involved with a project that is migrating data from sql server to
mysql. The project will take up to a year to complete. During that
period of time, we will need to synchronize data from sql server to
mysql as we migrate windows based functionality to linux based servers.
What i
Hi all,
I'm working for a company which has a administrative system under C# and
SqlServer and they have a payment system under PHP + MySql. The want I
create a trigger to update the SqlServer DB(Payments table) automatically
when a record is inserted in the MySql DB.
I've heard about LinkedServe
Thanks a lot - I'll try playing around with some of that stuff and at least get
the memory utilization between mySql and Sql Server comparable. At some point I
would like to see the abstraction layer running under mono - but won't get to
that for a while - when I do I can post l
ber 25, 2010 2:24 PM
To: Gavin Towey; [email protected]
Subject: RE: mySql versus Sql Server performance
Here's the innodb stuff - although the largest data set I've used in the stats
run is around 20MB, which doesn't seem like much to me.
'innodb_adaptive_hash_index
27;
'innodb_max_purge_lag', '0'
'innodb_mirrored_log_groups', '1'
'innodb_open_files', '300'
'innodb_rollback_on_timeout', 'OFF'
'innodb_stats_on_metadata', 'ON'
'innodb_support_xa', 'ON&
'0'
'innodb_mirrored_log_groups', '1'
'innodb_open_files', '300'
'innodb_rollback_on_timeout', 'OFF'
'innodb_stats_on_metadata', 'ON'
'innodb_support_xa', 'ON'
'innodb_sync_spin_loops&#
son [mailto:[email protected]]
Sent: Monday, October 25, 2010 12:31 PM
To: Gavin Towey; [email protected]
Subject: RE: mySql versus Sql Server performance
Query:
SELECT *
FROM Item
WHERE CollectionID = 'a0d3937b-f5a8-0640-dec8-bdd60f7f4775' AND
Ext
list.com/> - everything you could possibly want (to buy)
From: Martin Gainty [mailto:[email protected]]
Sent: Monday, October 25, 2010 3:53 PM
To: Patrick Thompson; [email protected]; [email protected]
Subject: [SPAM] RE: mySql versus Sql Server performance
Importance: Low
Patrick-
you'll w
) CHARACTER SET utf8 DEFAULT NULL,
`ObjectText` longtext NOT NULL,
`EnteredDate` datetime NOT NULL,
`LastModDate` datetime NOT NULL,
PRIMARY KEY (`CollectionID`,`ExternalID`),
UNIQUE KEY `ID` (`ID`),
KEY `ItemsByID` (`CollectionID`,`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29687 DEFAU
[email protected]
Subject: mySql versus Sql Server performance
I am running an open source project that provides an abstraction layer over a
number of different stores. I am puzzled by performance numbers I am seeing
between mysql and sql server - a brief discussion is available here
http://cipl.co
list.com/> - everything you could possibly want (to buy)
From: [email protected] [mailto:[email protected]] On Behalf Of Johan De
Meersman
Sent: Monday, October 25, 2010 9:55 AM
To: Patrick Thompson
Cc: [email protected]
Subject: Re: mySql versus Sql Server performance
I merely skimmed it, but y
- and post-5.
On Mon, Oct 25, 2010 at 3:38 PM, Patrick Thompson <
[email protected]> wrote:
> I am running an open source project that provides an abstraction layer over
> a number of different stores. I am puzzled by performance numbers I am
> seeing between
I am running an open source project that provides an abstraction layer over a
number of different stores. I am puzzled by performance numbers I am seeing
between mysql and sql server - a brief discussion is available here
http://cipl.codeplex.com/wikipage?title=Data%20Provider%20Comparison
The
> Does anyone have examples on creating stored procedures?
There are quite a few in
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
-
ML wrote:
I am working on moving a database from SQL Server to MySQL 5. Tables,
data, etc I already know.
I have some procedu
I am working on moving a database from SQL Server to MySQL 5. Tables,
data, etc I already know.
I have some procedures that i would like to move as well.
Does anyone have examples on creating stored procedures?
Best,
-Jason
--
MySQL General Mailing List
For list archives: http
Mário Gamito <[EMAIL PROTECTED]> wrote on 02/12/2008 01:00:25 AM:
> Hi,
>
> Is it possible to send an INSERT statement from a Windows server running
> MS SQL SERVER 2005 to a Linux box running MySQL ?
>
> If so, how ? Do I need any special tools ?
>
> Any help w
Save the sql statement to text file,then execute it inside the mysql shell.
On Feb 12, 2008 2:00 PM, Mário Gamito <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to send an INSERT statement from a Windows server running
> MS SQL SERVER 2005 to a Linux box running MySQL ?
&
Hi,
Is it possible to send an INSERT statement from a Windows server running
MS SQL SERVER 2005 to a Linux box running MySQL ?
If so, how ? Do I need any special tools ?
Any help would be appreciated.
Warm Regards,
Mário Gamito
--
MySQL General Mailing List
For list archives: http
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 Table
:
- 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 single quotes for strings;
Hope it helps.
On 1/23/08, J Trahair <[EMAIL PROTECTED]> wrote:
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 select
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 &
e thing is, my
data files may have "real" zeros in numeric columns, whereas NULL of course
is used to indicate an unknown value. When I migrate this application from
SQL Server to MySQL in the next couple of weeks, suddenly I'll have a lot of
zeros where I previously had NULLs.
Dan
Charles Walmsley wrote:
I don't think [EMAIL PROTECTED] should be used for sales. Is there a policy
about this?
My impression was that most people feel that the small number of product
advertisements that are directly related to MySQL are OK. That's only an
impression, but that's how I feel
t: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL
Server developer tool!
On Fri, 3 Mar 2006, David Griffiths wrote:
} Definitely give this tool a try if you haven't - it has some very powerful
} features - schema diffs (and the ability to create patches, etc - very
} powerful if yo
4Lin.
That's how the Opera (yes, from the browser) run Database
Workbench at their offices as they said in forum some time
ago :-)
> Feel free to spread this news!
>
> http://www.upscene.com/index.htm?dbw_party_promo.htm
Martijn Tonies
Database Workbench - tool for InterBase, Firebird,
On Fri, 3 Mar 2006, David Griffiths wrote:
} Definitely give this tool a try if you haven't - it has some very powerful
} features - schema diffs (and the ability to create patches, etc - very
} powerful if you maintain development, quality-assurance, and production
} databases).
}
} The ability
kbench supports InterBase, MySQL,
Firebird, Oracle and Microsoft SQL Server.
Feel free to spread this news!
http://www.upscene.com/index.htm?dbw_party_promo.htm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This week only, because of the 5-year celebration of
our database development IDE Database Workbench,
there's a 75% discount on ALL modules.
Database Workbench supports InterBase, MySQL,
Firebird, Oracle and Microsoft SQL Server.
Feel free to spread this news!
http://www.upscene.com/inde
On Sun, Sep 25, 2005 at 03:56:46PM -0500, Peter Brawley wrote:
> Jim,
>
> If you really want to return the result in a variable, declare a user
> var in the client, declare an OUT var in the SP, have the SP SELECT INTO
> it, and pass the user var to the SP in the call:
>
> SET @x=0;
> SET GLOBA
s(@x);
SELECT @x;
PB
http://www.artfulsoftware.com
-
Jim Seymour wrote:
Taking on online class for SQL and am down to the last two classes and
cannot make the following work. This is a MS SQL Server query that I
have not been able to solve through the MySQL Documentation:
CREATE PROCEDURE CountPhon
Taking on online class for SQL and am down to the last two classes and
cannot make the following work. This is a MS SQL Server query that I
have not been able to solve through the MySQL Documentation:
CREATE PROCEDURE CountPhoneNumbers AS DECLARE @count INTEGER
SELECT @count = COUNT (*) FROM
Hello,
> The platform we are working is Mysql 4.1.8 version
> and Windows XP os.
>
> In ms sql server the space used and free space
> available for each database is obtained through
> 'sp_spaceused'procedure( built in ).
>
> Primary memory used by ms
hello,
The platform we are working is Mysql 4.1.8 version
and Windows XP os.
In ms sql server the space used and free space
available for each database is obtained through
'sp_spaceused'procedure( built in ).
Primary memory used by ms sql server and related
ser
2k5,
> with a few higher limits. However consider that SQLServer Express is 1.)
> Not a shipping product (it's in Beta), and 2.) Requires the .Net
> framework version 2.0 to be installed (which is _also_ a beta), which
> (in my opinion) makes it not suitable for an ISV to look at _yet
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martijn Tonies wrote:
[snip]
| SQLExpress is not MSDE, it looks like it though. SQLExpress
| has a 4Gb limit/database and I don't recall a user limit, but a
| concurrent-load limit of 5. That is, many can connect, but only
| 5 concurrent batches (select
Hi Steve,
> In light of the licensing restrictions on using MySql in a commercial
> package, why would MySql be prefered over Firebird or SQL Server 2005
> express edition. Both appear to be no charge to redistribute compared to
the
> $250 for MySql.
>
> http://firebird.sourcef
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
|>FirebirdSQL is an excellent project, but as far as I know there is not a
|>single organization that stands behind it providing support, training,
|>etc. as MySQL AB does with the MySQL product line.
|
|
| Might want to take a
but it's there.
Cheers,
Justin
Quoting Mark Matthews <[EMAIL PROTECTED]>:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Steve Richter wrote:
>
> | In light of the licensing restrictions on using MySql in a commercial
> | package, why would MySql be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve Richter wrote:
| In light of the licensing restrictions on using MySql in a commercial
| package, why would MySql be prefered over Firebird or SQL Server 2005
| express edition. Both appear to be no charge to redistribute compared
to the
| $250
Mysql is easier to install than Firebird and runs in more Operative
Systems than SQL Server.
Steve Richter wrote:
In light of the licensing restrictions on using MySql in a commercial
package, why would MySql be prefered over Firebird or SQL Server 2005
express edition. Both appear to be no
In light of the licensing restrictions on using MySql in a commercial
package, why would MySql be prefered over Firebird or SQL Server 2005
express edition. Both appear to be no charge to redistribute compared to the
$250 for MySql.
http://firebird.sourceforge.net/
http://lab.msdn.microsoft.com
Hi,
> I am sure conversion questions are asked a lot, I need to move what is a
MS
> SQL Server database to a MySQL database, both table stuctures, data, and a
> web application with a very large number of queries.
>
> I am looking for any advice on this undertaking, things to be
The *best* way to do this is via conversion software. I find that for table
creation and data transfer, http://dbtools.com.br has the best free tool. It
converts all your Access and SQL based databases over to MySQL without any
hitches. Really good help files and web site as well.
Intelligent Conv
I am sure conversion questions are asked a lot, I need to move what is a MS
SQL Server database to a MySQL database, both table stuctures, data, and a
web application with a very large number of queries.
I am looking for any advice on this undertaking, things to be mindful of and
such, and if
> The staff on the other hand, is thinking in using
> ORACLE, and I need very solid arguments to beet them. Any ideas I can
borrow?
There is really only two arguments against Oracle as a DBMS - price and
closed source. But then you have to ask what the argument is against MySQL.
When I star
Leonardo : La verdad es que debes analizar lo que yo llamo "¿donde te
aprieta el zapato?" , esto quiere decir , que si requieres
procedimientos almacenados y triggers y vistas , quizas oracle haga el
trabajo. Si por otro lado la logica del negocio esta en tus
aplicacciones y no requieres de est
Leonardo Javier Belén wrote:
The staff on the other hand, is thinking in using ORACLE, and I need very solid arguments to beet them. Any ideas I can borrow?
If *you* don't know any arguments, then maybe Oracle is the best
solution.
Jochem
--
I don't get it
immigrants don't work
and steal our job
Hi folks!
I am sorry to bother but I need your help. At work I need to upgrade the data
management the place is using (very old FOXPRO DOS) with something more modern. The
use is only to store data and run multiple querys in a post mortem fashion. The data
source is a Ms SQL server so
On Tuesday 30 March 2004 10:53 am, Matt Chatterley wrote:
> Hi all,
hello.
> In-between lamenting the lack of views, one of the things I most miss from
> SQL Server, and which I need, is the Job System. For those unfamiliar with
> the concept from SQL Server, it is a way to set up
Hi all,
I hope I've chosen a suitable list for this post. If not, please feel free
to redirect me! :)
By day, I am a SQL Server (and .NET) programmer. By night, my current
project (a space-based trading/strategy game to be delivered on the web,
should anyone be interested in contacting m
Hallo,
MySQL ist selbst ein Datenbank-Server, d.h. man kann sich da hinverbinden,
Datenbanken anlegen, die wieder Tabellen enthalten. Diese Tabellen können
mehrere Spalten unterschiedlichen Typs haben, in die sich mit anderen
Befehlen (SQL-Sprache) Daten einfügen lassen (fast genau wie in Access,
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 m
Ich hätte da einige Fragen an Sie !
A - Sie sprechen, wenn sie über MYSQL reden einmal von einer
"MySQL, die populärste Open Source SQL-Datenbank, wird von MySQL AB"
dann wiederum ist es ein
"MySQL ist ein Datenbank-Managementsystem"
oder ein
"MySQL ist ein relationa
ually 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 it'll be the
> responsibil
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
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 boxe
at least match the features of SQL
Server, except maybe Postgres, and they run on more platforms and are
more scalable.
MySQL does have transaction support in the form of InnoDB tables.
Sub-queries are now supported in v4, although not the fastest
implementation. The other areas MySQL is lacking
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
> MySQL 5?
I have no
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 vers
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
dition, it contains a locking mechanism that is
> not adequate for tables containing many write actions
> occurring simultaneously from different users. It is also
> lacking in reference to support for software applications and
> tools.
>
> SQL Server 2000 is a complete Relational Data
or tables containing many write actions
occurring simultaneously from different users. It is also
lacking in reference to support for software applications and
tools.
SQL Server 2000 is a complete Relational Database Management
System (RDBMS) that also includes integrated analysis
functionali
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed
to a mySQL Server Database. The export works if there is at least one record in the
mySQL table. If the mySQL table is empty it gives an error that looks like this:
Insert error, column 1 (&#
lonzo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 13, 2003 4:30 PM
Subject: SQL Server 2000 to mySQL Server
> I'm trying to do an export from an SQL Server 2000 Database to and ODBC
driver pointed to a mySQL Server Database. The export works if there
Try SQLyog at http://www.webyog.com/sqlyog
I have used to import lots of data from SQL Server to
MySQL.
Karam
--- Martin Gainty <[EMAIL PROTECTED]> wrote:
> The official mySQL response is that you are
> overflowing the maxlength
> attribute
> Although there are many posts
n Windows 2000
> server on. I have been
> sent the MDF and LDF database files by the client...
> Does someone know
> of a way to convert those files to SQL without
> running Windows to do
> it? If not, is there an SQL-like format that SQL
> Server will save as
>
http://hotwired.lycos.com/webmonkey/99/21/index2a_page6.html?tw=programming
An example of PHP reading MySQL DB
Hth,
Martin
- Original Message -
From: "kumar mcmillan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 26, 2003 3:43 PM
Subject: how
o run Windows 2000 server on. I have been sent the MDF and LDF
database files by the client... Does someone know of a way to convert
those files to SQL without running Windows to do it? If not, is there an
SQL-like format that SQL Server will save as that I can request from the
client? Or is
F and LDF database files by the client... Does someone know
of a way to convert those files to SQL without running Windows to do
it? If not, is there an SQL-like format that SQL Server will save as
that I can request from the client? Or is there an application
(Windows or anything) that so
>I've read through the archives and spent hours on Google but I still can't
>figure this out. I must extract the data from a SQL Server *.DB file.
Viewing
>the raw text, I can see that there views, grants, etc. at the top of the
file,
>but this is a process that could n
I've read through the archives and spent hours on Google but I still can't
figure this out. I must extract the data from a SQL Server *.DB file. Viewing
the raw text, I can see that there views, grants, etc. at the top of the file,
but this is a process that could not possible be do
s, 'select * from country') Rowset_2
>
> The ADO access via Visual Basic works. But I would like to send the data
> directly from the SQL Server to MySQL, without intermediate.
>
>
> Best regards
> Anton
>
> -Ursprüngliche Nachricht-
> Von: Nils Valent
Would there be any reason why I couldn't have MySQL running on the same box
as SQL Server 2000?
Thanks,
Steve
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
MySQL Ge
Have you looked at using the MS DTS and MyODBC to perform your
replication/synchronizing from Microsoft?
-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:31 AM
To: [EMAIL PROTECTED]
Subject: Synchronising SQL Server and MySQL
I need to synchronise
lto:[EMAIL PROTECTED]
Sent: 19. juni 2003 11:31
To: [EMAIL PROTECTED]
Subject: Synchronising SQL Server and MySQL
I need to synchronise an SQL Server 2000 back end with a MYSQL database on a
different box (windows).
Can anyone point me in the right direction.
I have found a number of re
I need to synchronise an SQL Server 2000 back end with a MYSQL database on a
different box (windows).
Can anyone point me in the right direction.
I have found a number of resources on synchronising 2 sql server databases
but I cant find anything on SQLServer and MySQL.
Thanks in Advance
In MySQL-Front 2.5: How Do I Get Two Open Connection-Windows To Enable
Option to "EXPORT TABLES TO ANOTHER HOST/DB (Like Microsoft SQL Server
2000)" - Can It Be Done ?
This message and any attachments are confidential and intended solely for the
addressee.
Any unauthorized use, alt
There is one particular program that can dump an SQL Server database as
SQL statements much like mysqldump--its called SqlDump and it is
available from http://sqldump.sourceforge.net.
Ask your client to use it to give you the SQL file.
NOTE: the SQL stmts may be very much SQL Server specific
At 14:24 -0600 3/11/03, kenn murrah wrote:
Greetings.
I've been challenged with an assignment in which my client will feed
me a 9000-record SQL Server database every night, and I in turn
will need to import the data into mySQL, replacing the mySQL
database from the night before ...
CSV would be the easiest way.
-Shamit Verma
(http://vshamit.com)
- Original Message -
From: "kenn murrah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 12, 2003 1:54 AM
Subject: what's the best format option for importing SQL Server databas
Greetings.
I've been challenged with an assignment in which my client will feed me a 9000-record
SQL Server database every night, and I in turn will need to import the data into
mySQL, replacing the mySQL database from the night before ...
Given that scenario, and the fact that I obvi
wrote:
> 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 i
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
0, Chandra Amarasingham wrote:
Hi,
Any advice on porting stored procedures from sql server. I have looked at
UDF's but can't figure out how to use the existing database connection to
perform queries, also have not used C for a very long time.
Also had a brief look at myperl, but not well
Hi,
Any advice on porting stored procedures from sql server. I have looked
at UDF's but can't figure out how to use the existing database
connection to perform queries, also have not used C for a very long time.
Also had a brief look at myperl, but not well documented and sti
No; you can't recommend your own software, which has broken SQL support.
Try explaining to your customer why they can't use Oracle or DB2 while
you're at it. The database world is a _lot_ bigger than MS SQL Server.
We're already using classes for SQL translating, but only for
>From: Christian Reichenbach <[EMAIL PROTECTED]>
>
We encountered that MySQL (or MyODBC) uses different
quoting characters for legal names and strings.
>>>BSJ> Well, let's put it this way : tables names between
>>>BSJ> square brackets only exists in Microsoft!
>>>That might be right, but th
Hi Jan,
>>>We encountered that MySQL (or MyODBC) uses different
>>>quoting characters for legal names and strings.
>>BSJ> Well, let's put it this way : tables names between
>>BSJ> square brackets only exists in Microsoft!
>>That might be right, but this is how Microsoft works.
JS> I'm sorry, but
ers aren't using
BSJ> square brackets to specify columns and table names!
BSJ> So SQL is pretty standard here!
That might be right, but this is how Microsoft works.
I think it would be a big advantage if it is possible to use mySQL
instead of MS SQL Server not only at the startup of a
A few months ago I tried to use MySQL as an alternative database
backend for our software product. Currently we are using MS Access and
MS SQL Server.
We encountered that MySQL (or MyODBC) uses different quoting
characters for legal names and strings. At present we are using square
brackets for
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.I have two
problems. First is easy one,
First problem is to migrate big fields which had type varchar(7900) or
so I tried using Text datatype of mysql, is that the right one or I
should have used BLOB. That field doesnt contain any
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt&
Hi,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt"
1 - 100 of 176 matches
Mail list logo
