Any source with Microsoft SQL?

I'm getting certified in Microsoft SQL at work. Would I be able to setup a database in Microsoft SQL and have one of the sources connect to that or do I need MySQL?

Quote:

Originally Posted by TekiJinn I'm getting certified in Microsoft SQL at work. Would I be able to setup a database in Microsoft SQL and have one of the sources connect to that or do I need MySQL?

You can easily switch database systems to MSSQL.

Quote:

Originally Posted by TekiJinn I'm getting certified in Microsoft SQL at work. Would I be able to setup a database in Microsoft SQL and have one of the sources connect to that or do I need MySQL?

Sure! You'd need to change out the connector in the server project, translate some of the statements from MySQL syntax to SQL syntax, convert the table definitions into SQL, and import those definitions into MSSQL... but you could pretty easily like Arco said.

Generally... you'd use MySQL for hosting on Linux. You could host MSSQL on Linux now... but MySQL has been running on Linux for much much longer and is open-source.

Given the fact that you are asking basic questions regarding it. Stick to MySql.
SqlServer can get much more complicated in comparison to MySql.

Both run on Windows and Linux, SqlServer even runs faster on Linux based on benchmarks that Microsoft had shown.

I don’t know how in depth your course goes, let’s say it goes in depth, like answers mentioned you just need a simple conversion to support it. Depending on which .NET you are aiming at, you may just need a simple data conversion from one system to the other.