SQL Migration Archives - Page 7 of 7 - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Hands lifting a root-bound plant from a cracked clay pot, a larger new pot with fresh soil waiting beside it

Planning a Move Off an Old SQL Server Version

February 27, 2008

SQL Tips and Tricks

DBA, SQL Migration, SQL Server, SQL Upgrade

Plan a move off an old SQL Server version with a complete inventory, compatibility testing, a supported target, and a dated exit plan.

A child's bicycle beside a full-size one, a hand moving a red bell that does not quite fit the bigger handlebar

Migrating From Access to SQL Server: Data Types and Gotchas

December 12, 2007

SQL Tips and Tricks

SQL Datatype, SQL Identity, SQL Migration, SQL Server

Plan migrating from Access with explicit type mappings, boolean and date checks, query rewrites, and a primary key inventory.