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
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
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
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
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
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
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
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
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
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.convert-in.com/mss2sql.htm
I have done
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. But
I wanted to see if there is anything I should
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) hold more
-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
fields
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 before
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 list
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
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
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
@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
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 T-SQL
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 syntax especially without
an
MSSQL to MySQL mapping. Isn't there a mode to support T-SQL
@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
. Is 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 General
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
are not 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 you're
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
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
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
@ 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 respective data. I
Ooks Server [EMAIL PROTECTED] wrote:
I've run into a problem with the behavior of concat(). If I have two fields,
char(10), and I do this:
concat(field1,fields)
With MSSQL I get both fields including trailing spaces. With MYSql, I get
the two fields with the trailing spaces trimmed.
]
Subject: Re: concat() differences between mssql and mysql
Ooks Server [EMAIL PROTECTED] wrote:
I've run into a problem with the behavior of concat(). If I
have two fields,
char(10), and I do this:
concat(field1,fields)
With MSSQL I get both fields including trailing spaces
]
Subject: concat() differences between mssql and mysql
I've run into a problem with the behavior of concat(). If I
have two fields,
char(10), and I do this:
concat(field1,fields)
With MSSQL I get both fields including trailing spaces. With
MYSql, I get
the two fields with the trailing
-Original Message-
From: Ooks Server [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 4:38 PM
To: [EMAIL PROTECTED]
Subject: concat() differences between mssql and mysql
I've run into a problem with the behavior of concat(). If I
have two fields,
char(10), and I do this:
concat
I've run into a problem with the behavior of concat(). If I have two fields,
char(10), and I do this:
concat(field1,fields)
With MSSQL I get both fields including trailing spaces. With MYSql, I get
the two fields with the trailing spaces trimmed. Example:
Field1 = abc
Field2 = qwerty
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
NOTHING to do with how the information is being stored, just
how the information is being delivered to the client.
Any idea if something like this will ever be implemented in MySQL? If so
when?
If not I am afraid that if we decide to switch from MsSQL 2000 to MySQL will
be a painfull one.
Thanks
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 come
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 information in XML
: Re: Replication between MSSQL
and mySQL
03-01-2002
Hi All
I am not very experienced in databases so excuse me if the question is a
bit weird.
We have a SQL2000 database (about 15GB) and we want to develop some
webapplications to present the content. We dont want to use the current
DB-server but insted make a replica to run the application on,
Anything is possible, this will depend on your situation.
If you just want to replicate the data once, you can dump it all
in text format (say, tab-separated fields, CRLF-separated records)
onto a few CDs, and import them into MySQL using mysqlimport.
If you have the two machines networked,
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 application
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/manual.php (the manual
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
Subject: MSSQL to MySQL
hi..
is there any tool to convert MSSQL
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
-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
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 handle
47 matches
Mail list logo