[dba-Tech] SQL express version question

Gustav Brock gustav at cactus.dk
Fri Jul 29 11:04:54 CDT 2016


Hi Michael

You should also be aware of the minimum version of the host OS:

    https://msdn.microsoft.com/en-us/library/ms143506.aspx

I would go with the newest version possible although Access works with SQL Server back to at least version 2005.

/gustav

> Zimmer, Michael <mailto:Michael.Zimmer at federalmogul.com>
> Wednesday, July 27, 2016 12:00 PM
> Hello All,
>
> Currently at my work, we use literally dozens of MS Access databases 
> that clients utilize across our LAN.
> Now we are looking at migrating to a SQL Server. So a couple of us 
> here are beginning to dabble in SQL. Due to company policy, we have to 
> only deal with Microsoft products, so I've been looking at the 
> different flavors of SQL Server Express Edition.
>
> My question is what version of SQL Server Express should we be 
> learning on? 2014? Or 2016? What is the difference, if any, between 
> the versions? Any advantages/disadvantages?
>
> Thanks for any advice you can offer!
>
>
> Kindest personal regards,
>
> Mike 



More information about the dba-Tech mailing list