Migrating Your Data Tier to SQL Server: Strategies for Survival Video

TechEdPanel Discussion at Microsoft TechEd North America

Taped on May 13, 2009 at the Los Angeles Convention Center

Video: Migrating Your Data Tier to SQL Server: Strategies for SurvivalThis panel explores the different reasons and approaches for migrating applications to Microsoft SQL Server. In addition to moving the data to SQL Server, ideas are presented for transforming applications to offer additional features while watching budgets.

Examples are provided for migrating data from Oracle, Microsoft Access, and Excel to SQL Server. That's the easy part but often people need to consolidate and cleanup multiple applications and databases before upsizing the data to SQL Server.

Discussions also cover the challenges of maintaining and monitoring the new database, whether a database administrator is needed, and the life cycle of a SQL Server application.

Hear the panel discussion with Luke Chung, Richard Campbell, Stephen Forte, and Armen Stein, emceed by Microsoft's Mary Chipman.


Additional Resources

Strategic Overview

SQL Server Express

SQL Azure Cloud

What it Means to Information Workers

Link Microsoft Access to SQL Azure Databases

Deploy MS Access DBs linked to SQL Azure

Eliminate SQL Azure Security Holes

Monitor SQL Server Usage and DTU Limits on Azure

Convert Azure SQL Server to Elastic Pools

SQL Server Tips

Database Users and Permissions

Database Backup and Restore on Network

AM/PM Date Time Format

Get Date Portion


Running Total


Migrate Your Data Tier to SQL Server: Strategies for Survival

Microsoft Access Database and Migration Challenges

Are we there yet? Successfully navigating the bumpy road from Access to SQL Server

Visual Studio LightSwitch

LightSwitch Introduction

Comparison Matrix


Microsoft SQL Server Consulting Services

Visual Studio .NET programmers for web development

General Microsoft Access consulting services

Additional Resources

Microsoft Access Help

Microsoft Access Developer Help Center

MS Access Developer Programming

More Access and SQL Tips

Technical Papers

Microsoft Access Tools

Connect with Us


Free Product Catalog from FMS