Welcome Guest ( Log In | Register )




                Web Hosting Guide

 
 Reply to this topicNew 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
 

Reply to this topicNew Topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Collapse

> Similar Topics

    Topic Title Replies Topic Starter Views Last Action
No New Posts   2 xhrist14n 181 26th November 2009 - 05:28 AM
Last post by: starscream
No New Posts   3 khalilov 483 4th February 2009 - 09:14 AM
Last post by: Quatrux
No New Posts 0 rnd-am 453 18th December 2008 - 03:44 AM
Last post by: rnd-am
No New Posts   5 96than 5,245 23rd November 2008 - 02:20 AM
Last post by: Arbitrary
No New Posts 2 romeo123 599 22nd April 2008 - 03:51 PM
Last post by: yordan
No New Posts   7 java-area 1,030 22nd April 2008 - 03:41 PM
Last post by: yordan
No New Posts   9 Jimmy89 2,196 12th April 2008 - 02:28 PM
Last post by: iGuest
No New Posts   3 TheBoutique- 816 10th August 2007 - 10:57 AM
Last post by: yordan
No New Posts   7 Silver Bluewater 1,439 25th July 2007 - 10:02 AM
Last post by: yordan
No New Posts   14 lonebyrd 2,265 4th May 2007 - 06:32 AM
Last post by: TavoxPeru
No New Posts   6 olie122333 1,230 27th March 2007 - 06:42 AM
Last post by: sher
No New Posts   7 Jarvis 1,928 19th March 2007 - 12:07 PM
Last post by: vhortex
No New Posts 11 joe.k 1,603 31st January 2007 - 06:47 AM
Last post by: quinciest
No New Posts   4 mayoman123 2,229 16th September 2006 - 04:55 PM
Last post by: mayoman123
No New Posts   2 Demonhawk 996 6th August 2006 - 05:15 AM
Last post by: Demonhawk

© 2010  AstaHost: Free Web Hosting & Technical Discussion, Free Web Hosting. a member of xisto. Powered by Invision Board. Skin: IPB Forum Skins

Web Hosting Powered by ComputingHost.com.
HONESTY ROCKS! truth rules.
Creative Commons License