converting mysql to sql server script

[uglyeyes]

Hi All, there are softwares that automatically converts mysql to sql server script. i have below script and i want to convert into sql server 2000 format so please help me change this script to sql server format. many thanks in forward. --------------------- -- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 3.23.53-max-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Remove the CREATE line below if you already have a database setup. -- -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ dating_db; -- -- Change this to your database name. -- USE dating_db; -- -- Table structure for table `dating_db`.`abusereports` -- DROP TABLE IF EXISTS `abusereports`; CREATE TABLE `abusereports` ( `RecordID` int(10) unsigned NOT NULL auto_increment, `RecordDate` timestamp(14) NOT NULL, `AbuserID` int(10) unsigned NOT NULL default '0', `ReporterID` int(10) unsigned NOT NULL default '0', `ReporterComments` varchar(128) default '', `AbuseTypeID` tinyint(4) NOT NULL default '0', PRIMARY KEY (`RecordID`) ) TYPE=MyISAM; -- -- Dumping data for table `dating_db`.`abusereports` -- /*!40000 ALTER TABLE `abusereports` DISABLE KEYS */; /*!40000 ALTER TABLE `abusereports` ENABLE KEYS */; -- -- Table structure for table `dating_db`.`abusers` -- DROP TABLE IF EXISTS `abusers`; CREATE TABLE `abusers` ( `RecordID` int(10) unsigned NOT NULL auto_increment, `SuspensionDate` datetime NOT NULL default '0000-00-00 00:00:00', `DeletionDate` timestamp(14) NOT NULL, `FlagTypeID` tinyint(4) NOT NULL default '0', `AbuserUserName` varchar(16) NOT NULL default '', `AbuserEmail` text NOT NULL, PRIMARY KEY (`RecordID`) ) TYPE=MyISAM; -- -- Dumping data for table `dating_db`.`abusers` -- /*!40000 ALTER TABLE `abusers` DISABLE KEYS */; /*!40000 ALTER TABLE `abusers` ENABLE KEYS */; -- -- Table structure for table `dating_db`.`abusetypes` -- DROP TABLE IF EXISTS `abusetypes`; CREATE TABLE `abusetypes` ( `AbuseTypeID` tinyint(3) unsigned NOT NULL auto_increment,

[mcljava]

I just went through this exercise myself - a but of discovery plus trial and error. If you are used to the way MySQL works then you'll find SQL Server a different because most of the manual things we do in MySql like create databases and tables is done through graphical tools. One hot tip is the closest thing to writing SQL procedures like you do for MySQL is using iSQLW. You can enter SQL there but the syntax is slighty different. For creating tables, the EnterpriseManager is the primary tool you use to create the database and design the table(s). Although with the proper privilege you can create a database through Visual Studio Server connections - although that's a quick a dirty way. Lastly you need to know about Data Transformation Services (DTS) which is used for all import and exports of data. It has a broad choice of formats but alas no option for MySql option :sigh: Bottom line, if you have a lot of data in MySQL expect to get to know DTS and massaging the data. Good Luck Mike Luster CTI/IVR/Telephony SME