转换mysql数据库到SQL Server
问题描述:
我有一个MySQL数据库:转换mysql数据库到SQL Server
/*
MySQL Data Transfer
Source Host: 10.0.0.5
Source Database: jnetdata
Target Host: 10.0.0.5
Target Database: jnetdata
Date: 5/26/2009 12:27:33 PM
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for chavrusas
-- ----------------------------
CREATE TABLE `chavrusas` (
`id` int(11) NOT NULL auto_increment,
`date_created` datetime default NULL,
`luser_id` int(11) default NULL,
`ruser_id` int(11) default NULL,
`luser_type` varchar(50) default NULL,
`ruser_type` varchar(50) default NULL,
`SessionDay` varchar(250) default NULL,
`SessionTime` datetime default NULL,
`WeeklyReminder` tinyint(1) NOT NULL default '0',
`reminder_phone` tinyint(1) NOT NULL default '0',
`calling_card` varchar(50) default NULL,
`active` tinyint(1) NOT NULL default '0',
`notes` mediumtext,
`ended` tinyint(1) NOT NULL default '0',
`end_date` datetime default NULL,
`initiated_by_student` tinyint(1) NOT NULL default '0',
`initiated_by_volunteer` tinyint(1) NOT NULL default '0',
`student_general_reason` varchar(50) default NULL,
`volunteer_general_reason` varchar(50) default NULL,
`student_reason` varchar(250) default NULL,
`volunteer_reason` varchar(250) default NULL,
`student_nli` tinyint(1) NOT NULL default '0',
`volunteer_nli` tinyint(1) NOT NULL default '0',
`jnet_initiated` tinyint(1) default '0',
`belongs_to` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5913 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for tbluseravailability
-- ----------------------------
CREATE TABLE `tbluseravailability` (
`availability_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`weekday_id` int(11) NOT NULL,
`timeslot_id` int(11) NOT NULL,
PRIMARY KEY (`availability_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10865 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for tblusers
-- ----------------------------
CREATE TABLE `tblusers` (
`id` int(11) NOT NULL auto_increment,
`password` varchar(50) default NULL,
`title` varchar(255) default NULL,
`first` varchar(255) default NULL,
`last` varchar(255) default NULL,
`gender` varchar(255) default NULL,
`address` varchar(255) default NULL,
`address_2` varchar(255) default NULL,
`city` varchar(255) default NULL,
`state` varchar(255) default NULL,
`postcode` varchar(255) default NULL,
`country` varchar(255) default NULL,
`email` varchar(255) default NULL,
`emailnotes` varchar(255) default NULL,
`Home_Phone` varchar(255) default NULL,
`Office_Phone` varchar(255) default NULL,
`Cell_Phone` varchar(255) default NULL,
`Contact_Preference` varchar(255) default NULL,
`Birthdate` datetime default NULL,
`Age` varchar(255
而且持续了约10MB
我需要将其转换为MS SQL,我该怎么做呢?
答
看看在Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1
的Microsoft SQL Server迁移助手(SSMA)2008年是大幅降低工作量,成本,以及从MySQL迁移到SQL Server 2008和SQL Azure中的风险的工具包。针对MySQL v1.0的SSMA 2008 CTP1提供了对迁移工作的评估以及模式和数据迁移的自动化。