Upgrading your software can be daunting, Microsoft knows. The fast pace of business makes it easy to tell yourself, “I’ll do it later when I have time.” Microsoft gets it! But here are five key reasons to make time to upgrade to SQL Server 2016, which was named DBMS of the Year in 2016 by DBengines.com.
Seamless step-up without rewriting apps. Thanks to November’s SQL Server 2016 Service Pack 1 (SP1), SQL Server now has one programming surface across all editions. If you switch from Express to Standard, or Standard to Enterprise, you don’t have to rework code to take advantage of additional features. Time saved! In addition, the change brings access to innovative features across performance, security, and analytics not previously available in Express or Standard—a great reason to upgrade applications that run on those editions. The Enterprise edition of…
Before You Read
Microsoft supports various upgrade paths from WSS3.0/MOSS 2007 to SharePoint 2010. This post will highlight the “attach and upgrade” approach.
Run the Pre-Upgrade Check on the SharePoint 2007 Server
Execute the following command from the command line on the SharePoint 2007 server hosting the database to be upgraded:
stsadm –o preupgradecheck
This will scan the server for potential problems that may cause errors during the upgrade process.
Review the log file to get specifics on any issues. The most likely cause will be features or customizations, so make sure that you uninstall any features or customizations that aren’t necessary on the new server.
Back Up Your 2007 Content Database
Back up your 2007 content database from SQL Management Studio on the SharePoint 2007 server, and put the backup file somewhere it is accessible from the new SharePoint 2010 Server instance.
Restore the 2007 Content Database…