Member of the LearnItFirst.com Video Training Network	Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials

Create a free account · Sign In

SQL Server DBA Video Tutorial	Home Subscriber Videos

SQL Server Tutorial: Pt. 2 - Migration and Upgrade Options for Moving From Access to SQL Server

Chapter: Miscellaneous - Topics That Do Not Fit Anywhere Else!

Skill Level: 200 (Beginner - Intermediate)
Duration: 8:17
Size: 5.72MB
Versions/Editions Covered: SQL Server 2005 , SQL Server 2008 , SQL Server 2000
Added/Updated: Aug 01, 2007

This video covers the basic tools that you use to migrate from Access to SQL Server including discussions of differences in migrating the various versions of Access and SQL Server.

Highlights from this video:

Discussions on moving from Access 2007, 2003, 2000, XP, and even 97
Techniques for migrating one table at a time
Techniques for migrating all tables
Using DTS (Data Transformation Services) to upgrade to SQL Server 2000
Using SSIS (SQL Server Integration Services) for upgrades to SQL Server 2005
Text files as an upgrading option

and much more

Tags for this video: migrating migration upgrades upgrading

< Back

People Who Downloaded this Video Also Downloaded:

Title	Skill	Download
Part 1 - An Overview of the Default SQL Server Installation	100	Download
Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New To...	200	Download
Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage	200	Download
Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Com...	300	Download
Creating Database Diagrams in SQL Server Management Studio	200	Download

This video is part of the following video series: "How to Migrate From Microsoft Access to SQL Server"

So it's time to move away from using that friendly, rapid-application-development tool Microsoft Access and start using a full-blown relational database management system such as SQL Server, eh? There are many reasons to move from Access to SQL Server and this video gives you the primary reasons why people move from Access to SQL.

Highlights from this video series:
Differences between Access and SQL Server
Definitions of the ACID test and how it applies to SQL Server but not to Access
Memory and CPU support in SQL Server
How transactions are handled differently between the two systems
Using the Access Upsizing Wizard and understanding/overcoming its limitations
Using Access Data Projects (ADPs)
and much more

To view all videos in this series, click here

About the Instructor:

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott Whigham's full bio can be found on the About the Author page)

About Us

· Corporate Philosophy
· Advertise With Us
· Become an Author
· Contact Us

Video Playback

· System Requirements
· TSCC Codec (to play videos)
· Troubleshooting/Problems

Subscriptions

· Pricing/Buy Now
· Testimonials
· Privacy
· Terms of Service