0

I have made a web page which uses a local SQL database server.
Now that I want to publish the web page and place it online, I have to change everything, because the hosting server uses mySQL and presents me with his own mySQL database, and I don't know how to make that transition, I have an entity model in my solution and the Controller my database.

The specific question is - what are the steps to make that transition?

Improve this question
2
  • This is pretty broad. There is no formula for converting from one DBMS to another. Not all datatypes are going to have an exact match, not all the code will work the same way. Honestly switching from sql server to mysql because the host uses mysql is a pretty good indication that you need to find another host that allows sql server. Commented Feb 21, 2017 at 19:36
  • it's not my decision I didnt get the information in time, now I'm trying to fix the damage, I have that "server" mySQL I can run queries I can create tables but how do I place those tables inside of my webpage which is hosted?! how do I change the configuration online, they made it pretty stupid and twisted. Commented Feb 21, 2017 at 19:44

3 Answers 3

Reset to default
1

1 use SQL Tools (don't know what version you have) do a full backup.
2 from the new hosting server, restore the database.
3 change your connection strings or path (depends on programming environment) to use new MySQL.

Here is a link to what I used when I migrated in a similar way as to automate the whole process(Yes, it took a little learning but worth it). https://www.youtube.com/watch?v=rpPANKhbpDs

Improve this answer
Sign up to request clarification or add additional context in comments.

16 Comments

Also, if you explain a bit more about what systems you have it might be easier to help. :twc
I made the site in VS12015 and I have a connection string to my localDB, but now I was given mySQL php edition -.- which isn't helpful at all, because now I don't know what to change, where to change it, and what not, I really need someone to have patience and take me through it, the only thing I managed to do is make a table in the new mysql database
which info do You need? xD
You have two versions of SQL - Ok #1 - See if you can backup the myPHP SQL, download it and import it on your local SQL. You can do this using myPHPAdmin.
blogs.msdn.microsoft.com/uk_faculty_connection/2015/07/20/…
|
0

try to install mysql connector https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html

Improve this answer

Comments

0

MySQL Workbench provides you with the Migration Wizard feature. It allows you to migrate databases from various RDBMS products to MySQL.

This documentation would help you get started,... http://mysqlworkbench.org/2012/07/migrating-from-ms-sql-server-to-mysql-using-workbench-migration-wizard/

There are also several paid tools available which convert MS SQL to MySQL, but I've never used them personally. These tool come with free trial so you can actually test them before purchase. You can also refer similar threads on Stackoverflow,...

How to migrate SQL Server database to MySQL?

How to export SQL Server database to MySQL?

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.