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 to

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 anyone here is

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

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. Yoy

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

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

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 line script or

FW: RE: MSSQL to MySQL mapping

2005-08-22 Thread John ccccc
set? Thank you for your help John C From: Arjan Hulshoff [EMAIL PROTECTED] To: John c [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: RE: MSSQL to MySQL mapping Date: Thu, 11 Aug 2005 09:20:08 +0200 Have you adjusted your queries? MSSQL uses a different dialect (T-SQL), then MySQL

FW: RE: MSSQL to MySQL mapping

2005-08-22 Thread John ccccc
Also mysql complaints when I use the *= syntax: select a.userID from USers a, UserGroups b where a.UserGroupID*=b.UserGroupID; Any ideas? What is the equivalent syntax for MySQL. Thank you John C From: John c [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: FW: RE: MSSQL to MySQL

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

RE: RE: MSSQL to MySQL mapping

2005-08-22 Thread emierzwa
@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 *= syntax: select

RE: RE: MSSQL to MySQL mapping

2005-08-22 Thread John ccccc
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],mysql@lists.mysql.com Subject: RE: RE: MSSQL to MySQL mapping Date: Mon, 22 Aug 2005 09:49:32 -0400 User % instead

RE: RE: MSSQL to MySQL mapping

2005-08-22 Thread SGreen
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],mysql@lists.mysql.com Subject: RE: RE: MSSQL to MySQL mapping Date: Mon, 22 Aug 2005 09:49:32 -0400 User

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:

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

Re: MSSQL to MYSQL

2004-04-12 Thread Rodrigo Galindez
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 the save the script. 2. Add the Type=INNODB clause

RE: MSSQL to MYSQL

2004-04-11 Thread Matt Chatterley
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 Rodrigo. I'm facing a similar task but from

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. Divide

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

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 how about to MDB

2001-07-02 Thread Tiago Luchini
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? At 04:56 AM 07/02/2001 , you wrote: Yes

Re: MSSQL to MySQL how about to MDB

2001-07-02 Thread Joe Taraba
-Comercial Galluch Soluções Internet Telefax: 11 6912 3255 Celular: 11 3176 7740 http://www.galluch.com.br/ -Original Message- From: Joe Taraba [EMAIL PROTECTED] To: Tiago Luchini [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, July 02, 2001 2:28 PM Subject: Re: MSSQL to MySQL