0

Hi

I have a database running on MSSQL server 2005. Now I want to move all my data in MySQL server 5.

I am familiar with MySQL and PhpMyAdmin. Please help me what is the best way to do this.

Thanks

4
Contributors
7
Replies
9
Views
9 Years
Discussion Span
Last Post by bimaljr
0

Michael Kofler wrote a VBA module that will do this. You'll need Excel, Word, or a MS program that can run VBA. Here is the script with commented instructions on how to use and what variables to change. I've never used this but it looks like a very good, simple alternative to those pricey migration programs.

0

To buddylee1.7 : My MSSQL server is down now.. will try it.

Any more suggestions are also welcome...

If anyone has tried any other process or technique please reply here with descriptions

0

The .SQL file created successfully. But, when I was going to restore it, it gives me error.

I think the SQL file is based on mysql version 4.

The table structure is :

CREATE TABLE `db-development`.`aspnet_Applications`
(`ApplicationName` TEXT NOT NULL, 
`LoweredApplicationName` TEXT NOT NULL, 
`ApplicationId` TINYBLOB NOT NULL, 
`Description` TEXT NULL, 
INDEX `aspnet_Applications_Index`(`LoweredApplicationName`(255)), 
PRIMARY KEY(`ApplicationId`(16)), 
UNIQUE `UQ__aspnet_Applicati__58671BC9`(`LoweredApplicationName`(255)), 
UNIQUE `UQ__aspnet_Applicati__595B4002`(`ApplicationName`(255))) ENGINE InnoDB CHARACTER SET utf8;

The sql code is :

INSERT INTO `aspnet_Applications` (`ApplicationName`, `LoweredApplicationName`, `ApplicationId`, `Description`)  VALUES('0', '0', 0xCB965601D584422BA3972F5CBB91AF32, NULL);

The error is :

Error

SQL query:

INSERT INTO `aspnet_Applications` ( `ApplicationName` , `LoweredApplicationName` , `ApplicationId` , `Description` )
VALUES (
'0', '0', 0xCB965601D584422BA3972F5CBB91AF32, NULL
);

MySQL said: Documentation
#1062 - Duplicate entry 'Ë–VÕ„B+£—/\»‘¯2' for key 1

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.