Author Topic: Does EA 10 support SQL Server 2016?  (Read 1001 times)

mehdidarabi

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Does EA 10 support SQL Server 2016?
« on: November 16, 2017, 03:16:04 pm »
Hi friends,

As part of Windows 2008 end of life, I am planning to migrate our EA repository from SQL server 2008 R into SQL Server 2016. I was wondering whether this is supported by the older versions of EA? I am currently using EA10 (yes.. i am slow in upgrading!!!!) :)

Any tips and guidance are much appreciated.

Cheers
Mehdi

mehdidarabi

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Does EA 10 support SQL Server 2016?
« Reply #1 on: February 05, 2018, 03:19:19 pm »
does anyone know the answer?

Uffe

  • EA Practitioner
  • ***
  • Posts: 1274
  • Karma: +93/-8
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Re: Does EA 10 support SQL Server 2016?
« Reply #2 on: February 05, 2018, 08:16:13 pm »
Hello,

I haven't tried it but I don't see how there could be a problem.

The other way around possibly: if you want to enable row-level security, which EA recently added support for, that requires SQL Server 2016.
But an older EA version on a newer SQL Server version should not cause any issues.

I wouldn't recommend upgrading the server in place, though. It's safer to set up a 2016 server first, create an EA project on that and test it out, then migrate the old project(s) and finally decommission the 2008 server.

HTH,


/Uffe
My theories are always correct, just apply them to the right reality.

Graham_Moir

  • EA User
  • **
  • Posts: 704
  • Karma: +6/-9
    • View Profile
Re: Does EA 10 support SQL Server 2016?
« Reply #3 on: February 05, 2018, 09:46:27 pm »

EA 10 was "end of life" some time ago.  Perhaps you should consider upgrading EA as well?