November 28, 2016 at 5:40 am
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 😉
November 28, 2016 at 5:54 am
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
November 28, 2016 at 6:00 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply