Re: MSSQL to MySQL DataSync'er Prog

2006-10-26 Thread Ow Mun Heng
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

Re: MSSQL to MySQL DataSync'er Prog

2006-10-26 Thread Dan Buettner
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

Re: MSSQL to MySQL DB Syncronisation/Repl

2006-10-04 Thread Martijn Tonies
> 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

Re: MSSQL to MySQL DB Syncronisation/Repl

2006-10-04 Thread Ow Mun Heng
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

Re: MSSQL to MySQL DB Syncronisation/Repl

2006-10-04 Thread Ow Mun Heng
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

Re: MSSQL to MySQL DB Syncronisation/Repl

2006-10-04 Thread Martijn Tonies
> 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

Re: MSSQL to MySQL DB Syncronisation/Repl

2006-10-04 Thread Dan Buettner
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

RE: RE: MSSQL to MySQL mapping

2005-08-22 Thread SGreen
ntax especially without an > MSSQL to MySQL mapping. Isn't there a mode to support T-SQL statements in > MySQL. And if there is, what tool shall I use to change the sql_mode? > > Thank you > John C. > > >From: "Rajesh Mehrotra" <[EMAIL PROTECTED]>

RE: RE: MSSQL to MySQL mapping

2005-08-22 Thread John ccccc
T-SQL statements in MySQL. And if there is, what tool shall I use to change the sql_mode? Thank you John C. From: "Rajesh Mehrotra" <[EMAIL PROTECTED]> To: "John c" <[EMAIL PROTECTED]>, Subject: RE: RE: MSSQL to MySQL mapping Date: Mon, 22 Aug 2005 09:49:32 -0400

RE: RE: MSSQL to MySQL mapping

2005-08-22 Thread emierzwa
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

RE: RE: MSSQL to MySQL mapping

2005-08-22 Thread Rajesh Mehrotra
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

FW: RE: MSSQL to MySQL mapping

2005-08-22 Thread John ccccc
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

FW: RE: MSSQL to MySQL mapping

2005-08-22 Thread John ccccc
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

RE: MSSQL to MySQL mapping

2005-08-11 Thread Arjan Hulshoff
Have you adjusted your queries? MSSQL uses a different dialect (T-SQL), then MySQL uses. There are quite some difference, although some queries still might work. Arjan. -Original Message- From: John c [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 08:12 PM To: mysql@li

Re: MSSQL to MySQL mapping

2005-08-10 Thread Daniel Kasak
John c wrote: 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 Server 2000 are not accep

Re: MSSQL to MYSQL

2004-04-11 Thread Rodrigo Galindez
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

RE: MSSQL to MYSQL

2004-04-11 Thread Matt Chatterley
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

RE: MSSQL to MYSQL

2004-04-10 Thread David Carlos Brunstein
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 the save the script. 2. Add the "Type=INNODB" clause for each CREATE sentence. 3. Divid

Re: MSSQL to MySQL how about to MDB

2001-07-02 Thread Joe Taraba
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:

Re: MSSQL to MySQL how about to MDB

2001-07-02 Thread Tiago Luchini
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

Re: MSSQL to MySQL how about to MDB

2001-07-02 Thread Joe Taraba
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:56 AM 07/02/2001 , you wrote: >Yes look for mssql2mysql.txt on Mysql.com or even yahoo.com. > >Atenciosamente, > >Tiago Luchini >Diretor Técnico-Comercial >Galluch

Re: MSSQL to MySQL

2001-07-02 Thread Tiago Luchini
Yes look for mssql2mysql.txt on Mysql.com or even yahoo.com. Atenciosamente, Tiago Luchini Diretor Técnico-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 PROT