Changing from Mysql to MSSQL

Developed In: SQL — Contributed by: Mysql Tech

It's impossible to change Mysql to MSSQL just by changing the source . It's not difficult but requires the types correction and bringing them in compliance. Easy to solve it with a tool with data mapping functionality. Also views, triggers, and stored procedures have to be migrated manually

Mysql Tech
SQL 
  1. CREATE TABLE IF NOT EXISTS xhtml_table02 (
  2. the_id int(10) UNSIGNED NOT NULL,
  3. filename char (40) NOT NULL,
  4. PRIMARY KEY (the_id)
  5. ) TYPE=MyISAM AUTO_INCREMENT=2 ;
  6.  
  7. --
  8. INSERT INTO xhtml_table02 VALUES ( 1, `ncncncncncncn`) ;

Current Tags

mysql  mssql 

You must be logged in to tag this tool

No Comments yet

Votes

  • Rated 3.00 out of 5
Rated 3.00 out of 5 with 2 votes cast.
You must be logged in to vote.

Watches

0 members are watching this tool
You must be logged in to track this tool.

Provide Feedback

Please note:
HTML will be purified, but we allow for a number of HTML tags so that you have the flexibility to decorate your comment text to some extent. The comments allow the following HTML tags:

strong, b, em, blockquote, a, code, pre

To put code into your comment, simply encapsulate your code with
[code language="XXX"][/code], where XXX is any common language, for instance "PHP", "SQL", "C", etc.

You must be logged in to comment