fabiocardoso
Aug 7 2005, 09:56 AM
| | How to migrate my database from SQL Server to MySQL? |
Reply
Houdini
Aug 7 2005, 11:35 AM
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.
Reply
rodneylay
Aug 7 2005, 08:55 PM
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.htmlAfter 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
Reply
Similar Topics
Keywords : migrating, databases, migrating, mssql, server, mysql
- Mysql Multiple Tables
(1)
Any Website Provide Free Host Mysql Host?
(4) any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....
Database Access On Remote Server W/jsp
(0) Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
not sure exactly what needs to be packaged with my Java application to make it work. Since I
don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
JDBC driver would be bundled with my site but not sure. Thanks!....
Mysql On Computer
XD (9) I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
want and upload it when i get hosted =)....
Mysql Database Entry By Excel Sheets
(2) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE
(Store#, City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed
database for a bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST.
Consider that BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20.....
Mysql And User File_priv
(0) HI, I've hit the grain while trying to import file to mysql database - I need to enable file
permissions of the database user but this seems not possible with most of the hosting providers.
The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
allow privileges on table querries but you cannot grant host file privileges to the database user -
which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
I Have An Error With My Mysql Connection
mysql connection error (7) ok so here's my web page... http://lacrossems.t35.org/ it only lags cause its trying to
connect to the my sql server...i followed this guide
http://forum.ragezone.com/showthread.php?t=387249 and when i edit my config.php to my host and
login info i always get the error cannot connect to the database here is my config.php if you can
help me CODE <?php $host['naam'] =
'CENSORED'; // my host $host['gebruikersnaam'] =
'righto'; // my database username $host['wach....
Mysql Backup With Another Address?
(4) I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a
wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved
here at astahost, can I restore those backups? Is the change of the site address going to interfere
with this? Is there anyway I can edit those databases to work with my new address? Please help me
out here!....
Sun Bought Mysql
(6) SUN bought the swedish company MYSQL for much money, around 2million each worker got in the company,
they did it to come in to the database market, is it a good reson to buy it?....
Databases
(2) How do you access databases?Even though i don't have a hosting account yet i want to think
ahead. Please help thx, romeo123....
Free Graphical Tools For Databases
(7) There are a lot of different free software in Internet, but I have found only couple of free
graphical tools for database adminiatration. On another hand, MySQL is free for non commercial
usage. That's way it will be nice to have any good free GUI for this database. I remember the
time, when one of MySQL-Front versions was for free, but now it is opened only for testing period.
There is also free version of Toad, which is not full Toad, but it looks also very well - However, I
am not going to use Oracle (wchich is quite expensive commercial tool) on my desktop. The....
Mysql Problem
Linking tables (1) Hello guys, I'm making a PHP/MySQL site for a friend of mine who plays an online game where you
can create towns, add buildings to them and upgrade them to a newer level. I've offered to make
him a small site where he can input his data into a database and keep track of his towns, buildings
and levels. I'll show you my database design and then explain what i want to do. Table: towns
field 1: TownID (primary key, auto-increment) field 2: TownName field 3: TownType field 4: Town
Description Table: buildings field 1: BuildingID (primary key, auto-incremen....
Mysql - So Hard
Come in here if you think MySQL is soo hard! (14) Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of
databases just for one little script and you have to type things in like ;Host-Username:
(blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah) Ok, that MySQL code was
random, and it is alot harder than that. If you have expierenced it being hard, you are free to
post right in here, mate.....
Mysql Script Help
help me lol, (3) ok im a real noob to this myswql stuff i know what its for but can any1 write me a script for it for
user sigh up and like a myspace type of profile with a forms peferbly Wii FC code Games. Also can
some1 explain how to add the forms if it doset bother u guys too much TY....
Not Understanding Mysql
(4) Im not understanding MySql stuff can someone help me when u got to the MySql site and all that other
stuff is this like a log of your web stuff or does it help u desigen your website just wanted to
know what it does and how do u use this thing.....
Apache Php With Mysql On Windows [solved]
(9) I have problems running PHP MySQL function in a windows set web environment. PhP scripts are
executed but if I try to use mysql connect and other like functions I get a blank window (while
using the browser). The command line client is working...I've added the path to libmysql.dll
and the extension=php_mysql.dll in the php.ini.....
Subqueries In Mysql
Using subqueries in MySQL. Very helpful. (1) This method is very useful. I always use this when simple queries of linking two tables is not
enough. This method is putting a query inside a query. Example: SELECT * FROM table1 LEFT JOIN
(SELECT * FROM table2 WHERE field1='id') AS subtable or joining multiple queries SELECT *
FROM (SELECT * FROM table1 WHERE userid='001') AS subtable1 LEFT JOIN (SELECT * FROM table2
WHERE field1='id') AS subtable2 You can join more than two queries depending on the output
you want. If someone already posted this topic here I'm sorry I don't know.....
Oracle Vs. Mysql Vs. Postgresql
POLL!! Choses you preferred db s/w! (9) Hey Everyone!, Please choose your preferred database s/w! Regards, Avell....
Login System Using A Mysql Db
How do i do this? (5) Hi guys, ive got a registration system that looks something like the one below: Firstname:
Lastname: Then i have inset.php, which looks like the following: $con =
mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect:
' . mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person
(username, password) VALUES ('$_POST ','$_POST ')";if
(!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record
added";mysql_close....
Problems With Php Saving Data Into Mysql
HELP! I can't get my php documents to work with the mySQL (6) i have a server that says it allows php and mysql and in the control panel i can access mysqladmin
and phpmyadmin but i cant get the php to save data into the mysql, i am trying to make a text-based
MMOG so i need to save my users/passwords into a database(i thought) and it won't do it, can
anyone help me....
Mysql And Php
When trying to install Joomla (15) I don't know if this is the correct forum, but here is my question: I'm trying to test
Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache,
and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this
error: Required Settings Check: ------------------------------------- PHP version >= 4.1.0
Yes - zlib compression support Available - XML support Available - MySQL support
Unavailable configuration.php Writeable Session save path Unwriteable Not ....
Permission Problem With Mysql Database Creation
Please Help! (8) I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?....
Navcat For MySQL
is Navcat any good? (8) Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....
MySQL, Multiple Tables
(24) Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....
MySQL Output Database Question
(18) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
How To Connect MySQL With Flash?
Help me connect my flash Work with MySql (8) I know Flash and mysql but could not figure out if I could ever connect these? I want to have a
dynamic content in my flash object that could be retrieved from the database directly without myself
needing to update it again and again. How can I achieve this ? Do I have to install any additional
controls or connectors to do that ? If yes any one tell me....
Mirror My MySQL Database To Another Mysql Server
(4) Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Recover Tables From A MySQL .frm File
(8) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
MySQL - Trouble With Bulk Insert Statements
(3) I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
can have it tell me if there where any errors all the statements are executed? Thanks for your
help.....
Looking for migrating, databases, migrating, mssql, server, mysql
|
|
Searching Video's for migrating, databases, migrating, mssql, server, mysql
|
advertisement
|
|
