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
where SQLServer to
> MySQL have caused this
> error
> the solutions I have seen say go plain text and
> import using LOAD DATA
> INFILE
> Martin
> - Original Message -
> From: "David Alonzo" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
>
Greetings
What you need is a tool called SQLyog ( it has the
best ODBC import utility in the market ). A very good
tutorial can be found at http://www.devshed.com in the
MySQL section.
Do tell me how was your experience?
Karam ( A satisfied user of SQLyog )
--- kumar mcmillan <[EMAIL PROTECTED]
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
At 05:43 PM 7/26/2003 -0500, kumar mcmillan wrote:
Hi.
First, you will be happy to know that I am migrating a client to PHP/MySQL
from ASP/MSSQL. This is for reasons of future preservation, cost,
security, efficiency, et cetera. The problem is, I don't currently have a
PC and $$ to run Windows
Hi.
First, you will be happy to know that I am migrating a client to
PHP/MySQL from ASP/MSSQL. This is for reasons of future preservation,
cost, security, efficiency, et cetera. The problem is, I don't
currently have a PC and $$ to run Windows 2000 server on. I have been
sent the MDF and LDF
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
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
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"
Yes it is, at $139 I think it is a supper apps, if you are not sure try the
evaluation version
-Original Message-
From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2002 15:37
To: Norman Khine; Stan Lester
Cc: Mysql
Subject: Re: SQL Server 2000
You can't try
Cc: "Mysql" <[EMAIL PROTECTED]>
Sent: Sunday, January 06, 2002 3:06 AM
Subject: RE: SQL Server 2000
try http://www.appsolute.nl/heraut/
you can use importerscript to run db_dump.sql from you M$ SQL Server into
dezign and then change the db type to mysql.
hth
Norman
-Original Me
]
Subject: SQL Server 2000
Hi..
Is there any painless way or good documentation on how to convert a
database from Micro$soft $QL 2000 into MySql?
Thanks in advance for any directions you can point me to.
Stan
-
Before posting, please
al Message -
From: "Stan Lester" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 05, 2002 12:35 PM
Subject: SQL Server 2000
Hi..
Is there any painless way or good documentation on how to convert a
database from Micro$soft $QL 2000 into MySql?
Thank
Hi..
Is there any painless way or good documentation on how to convert a
database from Micro$soft $QL 2000 into MySql?
Thanks in advance for any directions you can point me to.
Stan
-
Before posting, please check:
http://www
as follows -
[TCX][MyODBC]You have an error in your SQL syntax near 'ID char (10) NULL,
Job Ref integer NULL, JobTitle char (100) NULL, DateAdd' at line 2
I have just used the default settings for export from SQL Server 2000.
All comments would be very gratefully received.
Many
18 matches
Mail list logo