|
MSSQL-to-MySQL is a program to migrate Microsoft SQL
databases to MySQL server.
Depending on your privileges on the target MySQL server you
can export MS SQL data into new database or overwrite the
contents of an existing MySQL database.
MSSQL-to-MySQL Features:
- All MS SQL data types and
attributes are supported
- Works with all versions of
MS SQL starting from 7.0
- Works with all versions of
Unix and Windows MySQL servers
- Merges MS SQL data into an
existing MySQL database
- Converts individual tables
- Converts indexes with all
necessary attributes
- Converts foreign keys
- Command line support
- VServer user's option
- Exports MS SQL databases
into MySQL dump file
- Easy-to-use wizard-style
interface
- Full install/uninstall
support
MSSQL-to-MySQL Limitations
- Does not convert stored
procedures
- Does not convert views
MSSQL-to-MySQL System Requirements:
- Windows 2000/XP or Windows
NT 4 with Internet Explorer 5 or later or Windows 98/ME or
Windows 95 with Internet Explorer 5 or later
- At least 32 MB of
available memory
- MS SQL environment (server
or client components of MS SQL must be installed on the same
machine where you run MSSQL-to-MySQL from)
VServer
user's option
If you are using Virtual Server hosting you probably have no
sufficient privileges to create new databases on the target
MySQL server. For this case we recommend the following
approach:
- ask your
Virtual Server administrator to create blank database for
you
- run
MSSQL-to-MySQL and select this database as the conversion
target
- click
"Yes" when you will be asked if you'd like to overwrite
existing MySQL database
When you
complete these steps, the entire contents of the source MS SQL
database will be imported into the specified MySQL database.
MySQL dump file
MSSQL-to-MySQL allows users to perform deferred conversion and
get more control over the process. Following this way, the
program stores the contents of the source database into a
local dump file instead of moving it to MySQL server directly.
The resulting file contains MySQL statements to create all
tables and to fill them with the data. You will be able to
import this file into existing MySQL database via MySQL client
as follows:
mysql.exe --host=... --user=... --password=... -vvf {MySQL
database name} < {dump file name}
|
