Pre-Requisites We usually think of SQL Server simply as a database engine, while it is a data platform which supports data warehousing, reporting, data integration and data analytics. An in-depth planning is required when upgrading from one version of SQL Server to a newer version along with the features that SQL Server offers. Upgrading these extensive number of features can be remarkably complicated and time-consuming than just upgrading the database engine alone. Below mentioned are few of the “lessons learned” that help reduce risks of data losses etc.: 1. Application compatibility: Before planning for upgrade activity, make sure that you discuss the compatibility of SQL Server and the associated application with your application vendor. 2. Preparation for migration: In case your upgrade activity fails due to some reason and there is no solution possible other than migration,...
Comments
Post a Comment