Buy SQLS-2016 Developer Editon

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  November 28, 2016 at 5:40 am

  #332343

  Hi,

  Can someone tell me a good source where i can buy sql for a good Price.

  AND

  what is a good whitepaper for migration from SQL 2008 / R2 to SQL2016;

  (Databases, SSAS, SSIS, Jobs, etc.)

  Thanks

  Regards

  Nicole 😉

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 28, 2016 at 5:54 am

  #1914691

  Developer Edition is free (for dev/test only). https://www.visualstudio.com/dev-essentials/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  November 28, 2016 at 6:00 am

  #1914693

  Nicole

  SQL Server 2016 Developer Edition is now free. As its name suggests, though, it's not for use in a production environment.

  As for migration, if white papers exist, they'll be out there - all you need to do is search for them. To simplify somewhat, the migration process I would recommend is as follows:

  (1) Run SQL Server 2016 Upgrade Advisor on your live servers (preferably at a quiet time)

  (2) Set up a test environment

  (3) Act on the recommendations from step (1) in your test environment

  (4) Move databases by backup and restore and change their compatibility level

  (5) Move other objects by scripting

  (6) Test thoroughly

  (7) Repeat in live when you're happy with performance and functionality.

  John

• November 29, 2016 at 9:33 pm

  This was removed by the editor as SPAM