Jump to content

Recommended Posts

hi,i have got a problem. i have database MSSQL and i want to migration to MYSQL.anysuggestion for me??because i want to build a Ecommerce site.btw anyone know the risk if we publish a database MSSQL using IP public??i think this is a second option if i can't migration to MYSQL. :Sad:

Share this post


Link to post
Share on other sites

in order to migrate from MS SQL to MySQL you can just export from MS SQL and import into MySQL both support export and important and because they are both based on SQL they should function okay in terms of accessing the database depending on the functions you've used you may have more problems for exmaple MySQL can use Limit where's MS SQL does not as one example. You should not need to publish a MS SQL using an IP address. we have a ms sql server and a web host that is located in a DMZ the web host and still talk to our MS SQL database without any problems and that does not have a public IP. Either way the damage to either a MS SQL and a MySQL data will also ways be the same, someone gets access and gets access and either manipulates the data, sells it or deletes it whether is is MySQL or MS SQL !

Share this post


Link to post
Share on other sites

thx for reply me...i really don't understand how MS SQL can still talk with your web host?? one year ago i buying a domain+host and i just using for email and FTP.....@_____@"can you explain how to connect MS SQL to web host??

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...