Welcome Guest ( Log In | Register )



 
 Reply to this topicStart new topic
> Migrating Databases, Migrating from MSSQL Server to MySQL
fabiocardoso
post Aug 7 2005, 09:56 AM
Post #1


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 25
Joined: 7-August 05
Member No.: 7,682
How to migrate my database from SQL Server to MySQL?
Go to the top of the page
 
+Quote Post
Houdini
post Aug 7 2005, 11:35 AM
Post #2


Super Member
Group Icon

Group: Members
Posts: 572
Joined: 25-April 05
From: Nashville Tennessee
Member No.: 4,340
Your question leaves a lot to be desired. SQL is structured query language MySQL is a database server that accepts the most common SQL syntax so there is nothing to do just create a data base using the SQL of
QUOTE
CREATE DATABASE  databasename;
then add a table to the database like CREATE TABLE tablename(all the parameters)
and so on you don't migrate SQL to MySQL you use SQL or PHP to control the behavior of MySQL ormssql or PostgreSQL. Please be more specific with your question and you might get a better response.
Go to the top of the page
 
+Quote Post
rodneylay
post Aug 7 2005, 08:55 PM
Post #3


Member [ Level 1 ]
Group Icon

Group: Members
Posts: 32
Joined: 5-August 05
Member No.: 7,649
QUOTE(fabiocardoso @ Aug 7 2005, 04:56 AM)
How to migrate my database from SQL Server to MySQL?
*



Depending on the size of your database structure it will be a fairly easy migration since both SQL Server and MySQL are nearly pure SQL database engines. If you follow the link below you will go to a very good tutorial on migrating to MySQL from SQL Server. This is from the MySQL.com website, and is the perfect place for you to learn MySQL once you do the migration.

http://dev.mysql.com/tech-resources/articl...-microsoft.html

After reading this tutorial you should have no problem. If you still are not sure what to do then you should probably hire someone to do the job for you. Good luck with your migration.

Rodney Lay
Go to the top of the page
 
+Quote Post
« Next Oldest · Databases · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL - Trouble With Bulk Insert Statements(3)
  2. MySQL Realtime Replication(4)
  3. Recover Tables From A MySQL .frm File(8)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. MySQL Output Database Question(18)
  7. MySQL, Multiple Tables(24)
  8. Navcat For MySQL(8)
  9. Permission Problem With Mysql Database Creation(8)
  10. Mysql And Php(15)
  11. Login System Using A Mysql Db(5)
  12. Oracle Vs. Mysql Vs. Postgresql(9)
  13. Subqueries In Mysql(1)
  14. Apache Php With Mysql On Windows [solved](9)
  15. Mysql - So Hard(14)
  1. Mysql Problem(1)
  2. Free Graphical Tools For Databases(7)
  3. Databases(2)
  4. Sun Bought Mysql(6)
  5. Mysql Backup With Another Address?(4)
  6. I Have An Error With My Mysql Connection(7)
  7. Mysql And User File_priv(0)
  8. Mysql Database Management(1)
  9. Mysql Database Entry By Excel Sheets(2)
  10. Mysql On Computer(9)
  11. Database Access On Remote Server W/jsp(0)
  12. Any Website Provide Free Host Mysql Host?(4)
  13. Mysql Multiple Tables(1)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 5th September 2008 - 05:50 AM
Powered By IP.Board 2.2.1 © 2008  IPS, Inc.
Licensed to: Xisto Corporation