Hi,
Mosh uses MySQL but I use MS SQL Server Management Studio and I’m getting some errors, does MySQL and MS SQL use different coding like some parts of the coding is written a bit differently because I think I might be face some issues in the future, please let me know, thank you.
Kind Regards,
Safwan
MS SQL is not the same as MySQL.
What helped me avoid connection issues between MySQL and my SMS system was making sure the firewall settings allowed the right ports. I also tested sending messages using sms.to directly from my database using a simple script, and it worked better once I got the API key correctly set in the config.
Hi
SQL is a standard so it should be the same. But actually to some point. Even MariaDB which is a fork from MySQL has differences.
For your information you don’t necessarily need to work with SSMS, though it is probably the most likely option.
Visual Studio with SSDT (SQL Server Data Tools) allows to do fun things such as write tests (pretty basic though) and mostly deploy your database.
Visual Studio code has official extensions that make it even better to use than the other two in regard of managing the scripts codebase.
Also you have Azure Data Studio. Did not use it much but the strong point it has built in notations that integrate well with querying the DB.
Surely Jetbrains has some tool and there might be more than that on other.
If it is about presenting a model I would advise dBeaver Community Editions at least.
Just giving pointers.
Cheers