On Thu, 2006-10-26 at 08:44 -0500, Dan Buettner wrote:
> I'm sure there are people who would find it useful! Post it on MySQL
> Forge - http://forge.mysql.com !
Will take a look at the site
>
> Dan
>
> On 10/26/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > Hi All,
> >
> > just wondering if an
I'm sure there are people who would find it useful! Post it on MySQL
Forge - http://forge.mysql.com !
Dan
On 10/26/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
Hi All,
just wondering if anyone here is interested in a (bash)script that does
DB replication/synchronisation between a MSSQL server t
Hi All,
just wondering if anyone here is interested in a (bash)script that does
DB replication/synchronisation between a MSSQL server to a MySQL server
running in Linux.
I just completed writing it and it seems to be working well, although
there are 1 or 2 more features which I would like to add.
> On Wed, 2006-10-04 at 17:22 +0200, Martijn Tonies wrote:
> > > Is there a tool available which can be used to transfer (periodically)
> > > between a MSSQL server and that of a MySQL Server?
> > > Is there anyone here who does this periodically? Either through a tool
> > > or via a command li
On Wed, 2006-10-04 at 17:22 +0200, Martijn Tonies wrote:
> > Is there a tool available which can be used to transfer (periodically)
> > between a MSSQL server and that of a MySQL Server?
> > Is there anyone here who does this periodically? Either through a tool
> > or via a command line script or s
On Wed, 2006-10-04 at 10:20 -0500, Dan Buettner wrote:
> You should check out
> http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-introduction.html
Yes. I've tried that. It works Great. (well, the only issue was I had to
change the structure of a few tables, but other than that
> Is there a tool available which can be used to transfer (periodically)
> between a MSSQL server and that of a MySQL Server?
> Is there anyone here who does this periodically? Either through a tool
> or via a command line script or something?
>
> Would appreciate any feedback or suggestions.
Yo
You should check out
http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-introduction.html
Dan
On 10/4/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
Hi,
Is there a tool available which can be used to transfer (periodically)
between a MSSQL server and that of a MySQL Server?
Is t
Hi,
Is there a tool available which can be used to transfer (periodically)
between a MSSQL server and that of a MySQL Server?
Is there anyone here who does this periodically? Either through a tool
or via a command line script or something?
Would appreciate any feedback or suggestions.
Thanks
-
.
Ed
-Original Message-
From: Ryan Stille [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 7:38 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: Intelligent Converters product: MSSQL-to-MySQL
> OK, you confused me. How can 16 be bigger than 16? For character-based
>
> OK, you confused me. How can 16 be bigger than 16? For character-based
> fields, the number in the parentheses shows the length of the field,
> does it not? The first part, the "text" or "char" or "varchar" or ...,
> tells the engine what kind of data a field will contain.
> How can TEXT(16) ho
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 09/13/2005 08:42:05 AM:
> Josh Chamas wrote:
> > Ryan Stille wrote:
> >> Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
> >> reasonable at $40, and the demo output I got looked pretty good
Josh Chamas wrote:
> Ryan Stille wrote:
>> Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
>> reasonable at $40, and the demo output I got looked pretty good. But
>> I wanted to see if there is anything I should be weary about.
>> http://www.conve
Ryan Stille wrote:
Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
reasonable at $40, and the demo output I got looked pretty good. But I
wanted to see if there is anything I should be weary about.
http://www.convert-in.com/mss2sql.htm
I have done a test migration b
Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
reasonable at $40, and the demo output I got looked pretty good. But I
wanted to see if there is anything I should be weary about.
http://www.convert-in.com/mss2sql.htm
Thanks,
-Ryan
--
MySQL General Mailing List
For
uot;John c" <[EMAIL PROTECTED]> wrote on 08/22/2005 04:04:58 PM:
>
> Thank you for your e-mail, but it did not work. In any case it does not
make
> a lot of sense to go back to a 1000 page application and identify every
> single T-SQL syntax and convert it to a MySQL sy
Thank you for your e-mail, but it did not work. In any case it does not make
a lot of sense to go back to a 1000 page application and identify every
single T-SQL syntax and convert it to a MySQL syntax especially without an
MSSQL to MySQL mapping. Isn't there a mode to support
ccc; mysql@lists.mysql.com
Subject: RE: RE: MSSQL to MySQL mapping
User % instead of *
-Original Message-
From: John c [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 9:48 AM
To: mysql@lists.mysql.com
Subject: FW: RE: MSSQL to MySQL mapping
Also mysql complaints when I use the
User % instead of *
-Original Message-
From: John c [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 9:48 AM
To: mysql@lists.mysql.com
Subject: FW: RE: MSSQL to MySQL mapping
Also mysql complaints when I use the *= syntax:
select a.userID from USers a, UserGroups b where
I set the sql_mode, with what tool, how do I ensure what sql mode is
currently set?
Thank you for your help
John C
From: "Arjan Hulshoff" <[EMAIL PROTECTED]>
To: "John ccccc" <[EMAIL PROTECTED]>
CC:
Subject: RE: MSSQL to MySQL mapping
Date: Thu, 11 Aug 2005
currently set?
Thank you for your help
John C
From: "Arjan Hulshoff" <[EMAIL PROTECTED]>
To: "John c" <[EMAIL PROTECTED]>
CC:
Subject: RE: MSSQL to MySQL mapping
Date: Thu, 11 Aug 2005 09:20:08 +0200
Have you adjusted your queries? MSSQL uses a differe
@lists.mysql.com
Subject: MSSQL to MySQL mapping
We have a web based application running on IIS 5.0 using MS SQL Server
2000 as the DBMS; we use ODBC to connect to the DB. We migrated our DB
to MySQL and used the MySQL ODBC driver. It appears that some of the SQL
statements that are accepted by SQL
accepted
by MySQL. Is there a mapping from MSSQL to MySQL statements?
Not that I know of, but that would be a good idea.
If you can't find the function that you're after in the docs, you can
always post to the list for help ... and maybe compile that list of
mappings while yo
We have a web application that uses SQL statements and interacts via an ODBC
interface to MS SQL Server. When we changed the DBMS to MySQL some of the
SQL statements are not accepted by MySQL. Is there a mapping between MSSQL
to MySQL statements?
Thank you
John C
there a
mapping from MSSQL to MySQL statements?
Thank you
John C.
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
MySQL Ge
3
To: 'Rodrigo Galindez'
Cc: [EMAIL PROTECTED]
Subject: RE: MSSQL to MYSQL
Hi Rodrigo.
I'm facing a similar task but from Informix to MySQL. What I do is:
1. Obtain a SQL script to create the logical database (an Informix tool
give it). You can use Erwin, with reverse engineer and th
database structure
itself, without embedded code though, it should work perfectly...
Cheers,
Matt
-Original Message-
From: David Carlos Brunstein [mailto:[EMAIL PROTECTED]
Sent: 11 April 2004 05:23
To: 'Rodrigo Galindez'
Cc: [EMAIL PROTECTED]
Subject: RE: MSSQL to MYSQL
Hi
DavidBrunstein @ Hotmail . Com
-Original Message-
From: Rodrigo Galindez [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 10, 2004 3:38 AM
To: [EMAIL PROTECTED]
Subject: MSSQL to MYSQL
Hello list,
I have to move a database in MSSQL to MYSQL, with the table
structures and all the res
Hello list,
I have to move a database in MSSQL to MYSQL, with the table
structures and all the respective data. I tested one product to do this,
SQLyog, and it works fine, except for some little problems with indexes
and primary/secondary keys. I want to know if anyone have been dealing
First off i am a newbie, so forgive any repatition and ideocy.
Ok i am trying to evaluate MySQL, i have a Mssql database which has been
specifically generated by my company. Therefore i have a ddl file which
will generate the tables, database name and relationships. I have poked
around mysql a
On Monday 18 February 2002 13:05, Dan Nelson wrote:
> In the last episode (Feb 18), Marcelo Iturbe said:
> > Hello,
> > Currently I have an aplication which stores the information in an MsSQL
> > database in a straight forward manner, "insert into blah blah"
> >
> > However, I retrieve the informa
In the last episode (Feb 18), Marcelo Iturbe said:
> Hello,
> Currently I have an aplication which stores the information in an MsSQL
> database in a straight forward manner, "insert into blah blah"
>
> However, I retrieve the information in XML format using the FOR XML EXPLICIT
> statements that
Hello,
Currently I have an aplication which stores the information in an MsSQL
database in a straight forward manner, "insert into blah blah"
However, I retrieve the information in XML format using the FOR XML EXPLICIT
statements that come with MsSQL 2000.
The select stament looks something like
Hi.
On Tue, Nov 06, 2001 at 12:34:26AM -0700, [EMAIL PROTECTED] wrote:
> In MSSQL I can aggregate various fields like the [totalRev] field listed
> below:
>
> Does anyone know if or how to do this in MySQL?
You can't. You only can do this in the SELECT clause or make a column
that your applicat
EMAIL PROTECTED]>
>Date: Monday, July 02, 2001 2:28 PM
>Subject: Re: MSSQL to MySQL how about to MDB
>
>
> >Just curious, can you convert access database to MySQL and visa versa.
> >Meaning from win98 access 2000 to Linux Mysql 3.22.32?
> >
> >At 04:
lt;[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, July 02, 2001 2:28 PM
Subject: Re: MSSQL to MySQL how about to MDB
>Just curious, can you convert access database to MySQL and visa versa.
>Meaning from win98 access 2000 to Linux Mysql 3.22.32?
>
&g
Comercial
>Galluch Soluções Internet
>Telefax: 11 6912 3255
>Celular: 11 3176 7740
>http://www.galluch.com.br/
>-Original Message-
>From: Lok Woei Ming <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>Date: Sunday, July 01, 2001 1:14 PM
>
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Sunday, July 01, 2001 1:14 PM
Subject: MSSQL to MySQL
hi..
is there any tool to convert MSSQL to Mysql?
regard
-
Before posting, please check:
http://www.mysql.com/manua
hi..
is there any tool to convert MSSQL to Mysql?
regard
It doesn't currently. Currently, you can't use subselects.
Cal
http://www.calevans.com
-Original Message-
From: Michael Blood [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 5:12 AM
To: MYSQL
Subject: Another MSSQl to mysql question.
does any one know how mysql can
Title: Blank
does any one know how mysql can handle an
exists query.
for example
select xcolumn from ytable
where exists (select 1 from ztable where
ytable.id = ztable.id)
I realize that in this particular example I
can rearrange my query but there are lots of other queries where I find
41 matches
Mail list logo
