>>>>>>> Is MS SQL your only choice?
>>>>>We use MS SQL LocalDB on the client machine - The Linked Server feature is provides a very fast transfer of required data from the primary server to the local pc.
>>>>
>>>>Hmmm localDB. I think that is not suggested in production, only for developer testing. Express is a better choice IMHO.
>>>
>>>Unless your final production or distributed SQL Server is going to be the Express version I would suggest developing using the FREE MSSQL Developer edition. Why not? It's as close to the real thing, with some exceptions, that you will need on your development machine. You can even install it at home.
>>>
>>>
https://www.microsoft.com/en-us/sql-server/developer-tools>>>
>>>I think the above link will get you there. If you have MSDN you can definitely find it there as well.
>>
>>Nope it is not as close to the real thing. It is for free, true and I already have it installed. It is as close to the real thing when the real thing is
Enterprise edition. However, as a developer you might be developing to support from express and up.
>
>Like I said, 'Unless your final production or distributed SQL Server is going to be the Express version...'. As a developer in the corporate environment I have never worked with the Express version. My post is to inform people that the Developer edition of MSSQL is available FREE and I suspect a lot of people don't know that.
It doesn't need to be just express version. There are other editions like standard, web. You can check this link for editions:
https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017I don't only develop for in-house and our customers have versions\editions ranging from 2005 Express...Enterprise to 2017 Express .... Enterprise. So I have to check stuff against the common lowest one unfortunately (if it were all left to me, I wouldn't even choose MS SQL but postgreSQL).
PS: Yes I have been using developer editions since pre 2005 and it was something like 49$ then. Recently made fro free (maybe a little bit late to catch open source train).
