» » Migrating Access Databases to SQL Server

Information of news
16-10-2015, 10:16

Migrating Access Databases to SQL Server

Category: Tutorials

Migrating Access Databases to SQL Server
Migrating Access Databases to SQL Server
Duration: 2hr 39m | Video: h264, yuv420p, 1280x720 30fps | Audio: aac, 44100 Hz, 2 ch | 405MB
Genre: eLearning | Language: English

At one point Access was adequate. But what happens when your database grows and you need more powerful tools? You can move it! Migration allows you to take advantage of SQL Server's advanced features, and maintain a link to the data in Access.

Watch this course to learn how to leverage what you already know to take that next step. Adam Wilbert reviews the basics of SQL Server Management Studio (SSMS) and introduces two workflows for migrating Access data: one using a simple export/import process and the other using the free SQL Server Migration Assistant (SSMA). He also shows how to convert Access to SQL data types, link Access to SQL data via an ODBC connection, and address special concerns for Access 2010 data.

Topics include: Why upgrade?Importing a SQL databaseExploring data types and server objectsInstalling SSMAMapping source and target data typesUsing the Migration WizardLinking to migrated tables in SSMAWorking with views and stored proceduresLinking Access to SQL Server databases
Download link:



Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

free html hit counter