Posts

Showing posts from December, 2013

SQL SERVER Upgrade: SQL2012 features

Image
Time to upgrade your old SQL server to SQl2012:
Why we consider the SQL Server to upgrade from old version?
SQL2012 consists of important features that are not available in the old versions.

Nice features of SQL Server 2012.
1. Contained databases help to avoid the database user’s creation in the destination server after migration.
2. Server Core support significantly reduces the patching.
3. Security-User defined server role helps to create custom defined server role in SQL 2012 server.
4. Column store index assists in storing of the data as like column instead of old row level storage to improve the data access performance.
5. Tabular model mode to help personal BI users to achieve their work in excel to SSAS.
6. Data Quality Service to help BI users to implement the standards and quality of data in SSAS.
7. Power View helps end users to drag and drop the required field for analysis and report purposes in BI.
8.AlwaysOn Availability Groups helps to failover the databases as a single entity, …

SQl2000 to SQL2008R2 Database Migration Scripts steps

Steps required for Database migration from SQL2000 to SQL2008R2.
Follow the below steps to migrate the database from older version (SQL2000) to another version SQL2008R2. Backup the production database required and keeps it for restore into a new version SQL server.
1. Backup live Database BACKUPDATABASEkumarDB TODISK='Z: \SQLServerBackups\kumarDB.bak' GO
2. Restore live Database to new server ----Restore Database RESTOREDATABASEkumarDB FROMDISK='D:\kumarDB.bak' WITHMOVE'YourMDFLogicalName'TO'D:YourMDFFile.mdf', MOVE'YourLDFLogicalName'TO'D:YourLDFFile.ldf'

3. Generate the scripts required for changing the column collation. (COL 1 Generate_change_column_collation); Keep the scripts for future use. declare@toCollationsysname
SET@toCollation='Latin1_General_CI_AS'-- Database default collate
SELECT'ALTER TABLE '+INFORMATION_SCHEMA.COLUMNS.TABLE_NAME+ ' ALTER COLUMN '+COLUMN_NAME+