Can Studio Management for MS SQL Work with MySQL

[nector]

Sorry People,

For the purpose of switching over from MS SQL Server which I'm used with to MYSQL which I have never used before I want to find out whether the SSMA studio can still be used to create tables, view and stored procedures for the cloud database under MYSQL. We have been doing this way under UZURE for MS SQL Server. The swicth is necessary because the provider is a local company with only less 5 kilometers away from our office and can be easy to engage physically.

 

[theDBguy]

Probably not. Normally, you would use MySQL Workbench to work with MySQL.

Just in case you're interested, check out this post.

Thread 'DBeaver — A better, free cross-platform database tool, with Kevin Bell'

Jul 30, 2024

Please join us for our Monthly Chapter Presentation August 1, 2024 , at 6:30PM Pacific (UTC -7)

Building Dynamic Entity Relationship Diagram with DBeaver

The adage “a picture is worth a thousand words” aptly captures the essence of an Entity-Relationship Diagram (ERD). Similar to this metaphor, an ERD provides a visual depiction of the intricate relationships among entities within a database. If you’ve ever crafted an ERD in Access or SQL Server, you might agree that a significant portion of those “thousand words” might lean towards the concise, four-letter variety...

• GPGeorge
• Replies: 9
• Forum: Microsoft Access User Groups

 

[GPGeorge]

Sorry People,

For the purpose of switching over from MS SQL Server which I'm used with to MYSQL which I have never used before I want to find out whether the SSMA studio can still be used to create tables, view and stored procedures for the cloud database under MYSQL. We have been doing this way under UZURE for MS SQL Server. The swicth is necessary because the provider is a local company with only less 5 kilometers away from our office and can be easy to engage physically.

SQL Server Migration Assistance has several versions, including one for MySQL. A quick internet search found it for you.

Download Microsoft SQL Server Migration Assistant for MySQL from Official Microsoft Download Center

Microsoft SQL Server Migration Assistant (SSMA) for MySQL is a tool to automate migration from MySQL database(s) to SQL Server, Azure SQL Database and Azure SQL Database Managed Instance.

www.microsoft.com

Or perhaps you meant SSMS, not SSMA. If so, check us out on Thursday night as we learn about a tool that works with numerous databases, including Access, SQL Server and MySQL.

 

[cheekybuddha]

I use DBeaver to connect to both MySQL and SQLServer (and also PostgreSQL on the rare occasion!)

 

[nector]

Many thanks for the valuable information, actually it has turned out to be cpanel to do the job that we normally do in MS SQL Management Studio , we need to download Mysl connector ODBC depending to the window bit installed. Exporting is just the same like wo do it one by one using ODBC

(1) We need to create the database in Mysl using cpanel
(2) Create a user to manage the database + password

Lastly link the MS Access Front end using ODBC