MIGRATING ACCESS DATABASES TO SQL

RELEASED EXCLUSIVLY
FOR SCENE USAGE ON

[PUBLISHER] LYNDA
[RUNTIME  ] VIDEO DURATION: 0S    [LINK]
[LEVEL    ] INTERMEDIATE          [TYPE] RETAIL
[ISO SIZE ] 408.991.744 B         [CHKS] 6E5297DC
[ON STORE ] 2015.10.06            [$$$$] 200000000000 DOLLAR
[DISKNAME ] keiso_lmadtosqls
[HELD BY  ] ADAM WILBERT

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 database

* Exploring data types and server objects

* Installing SSMA

* Mapping source and target data types

* Using the Migration Wizard

* Linking to migrated tables in SSMA

* Working with views and stored procedures

* Linking Access to SQL Server databases

[SHOUTOUTS.TO.OUR.FRIENDS.IN]

[ACTiVATED]-[AZR]-[BRD]-[COMPRISED]
[CORE]-[DEBOOK]-[DVT]-[iRONISO]
[LAXiTY]-[LMS]-[NOY]-[OUTLAWS]