| 001 Welcome.mp4 | 5.64 MB | ||
| 002 What you need to know.mp4 | 962.16 KB | ||
| 003 Using the exercise files.mp4 | 3.15 MB | ||
| 004 Understanding front ends and back ends.mp4 | 8.72 MB | ||
| 005 Benefits of a SQL Server back end.mp4 | 7.57 MB | ||
| 006 Understanding SQL Server editions.mp4 | 10.3 MB | ||
| 007 Installing SQL Server Express 2014.mp4 | 11.62 MB | ||
| 008 Starting and stopping SQL Server.mp4 | 5.18 MB | ||
| 009 Using SQL Server Management Studio.mp4 | 21.85 MB | ||
| 010 Importing a SQL database.mp4 | 9.04 MB | ||
| 011 Understanding SQL Server data types.mp4 | 15.52 MB | ||
| 012 Importing SQL Server objects.mp4 | 25.68 MB | ||
| 013 Editing the table design in SSMS.mp4 | 16.13 MB | ||
| 014 What is SQL Server Migration Assistant_.mp4 | 3.98 MB | ||
| 015 Downloading and installing SSMA.mp4 | 8.15 MB | ||
| 016 Creating the empty SQL Server database.mp4 | 1.58 MB | ||
| 017 Preparing the Access database.mp4 | 5.17 MB | ||
| 018 Setting default SSMA project options.mp4 | 8.66 MB | ||
| 019 Mapping source and target data types.mp4 | 5.81 MB | ||
| 020 Identifying the Access objects to migrate.mp4 | 4.88 MB | ||
| 021 Creating an SSMA project.mp4 | 9.63 MB | ||
| 022 Creating an assessment report.mp4 | 8.73 MB | ||
| 023 Fixing common migration errors.mp4 | 8.59 MB | ||
| 024 Running the SSMA project.mp4 | 12.56 MB | ||
| 025 Backing up the database.mp4 | 2.47 MB | ||
| 026 Using the SSMA Migration Wizard.mp4 | 12.48 MB | ||
| 027 Exploring the results in SQL Server Management Studio.mp4 | 8.52 MB | ||
| 028 Exploring the changes to Access.mp4 | 10.02 MB | ||
| 029 Relinking tables after structural changes.mp4 | 12.72 MB | ||
| 030 Linking new SQL tables from a production database.mp4 | 16.11 MB | ||
| 031 Linking to ODBC databases.mp4 | 2.66 MB | ||
| 032 Attaching the SQL database.mp4 | 5.52 MB | ||
| 033 Creating the data source.mp4 | 14.03 MB | ||
| 034 Establishing the table links in Access.mp4 | 9.8 MB | ||
| 035 Adding records to linked tables.mp4 | 17.39 MB | ||
| 036 Linking to SQL Server views.mp4 | 13.3 MB | ||
| 037 Preparing to upsize.mp4 | 4.8 MB | ||
| 038 Using the Upsizing Wizard.mp4 | 18.74 MB | ||
| 039 Editing tables.mp4 | 8.4 MB | ||
| 040 Migrating queries.mp4 | 11.47 MB | ||
| 041 Next steps.mp4 | 2.44 MB | ||
| Exercise Files | |||
| Chapter 1 | |||
| KinetEco.accdb | 3.1 MB | ||
| Chapter 2 | |||
| KinetEco-Import.mdf | 4 MB | ||
| KinetEco-Import_log.ldf | 1.25 MB | ||
| KinetEco.accdb | 3.1 MB | ||
| Products.txt | 4.33 KB | ||
| Chapter 3 | |||
| KinetEco-SSMA.accdb | 3.77 MB | ||
| Chapter 4 | |||
| KinetEco-MigrationWizard.accdb | 3.1 MB | ||
| Chapter 5 | |||
| KinetEco-ODBC.accdb | 336 KB | ||
| KinetEco-ODBC.mdf | 4 MB | ||
| KinetEco-ODBC_log.ldf | 1.25 MB | ||
| Chapter 6 | |||
| KinetEco-Upsize.accdb | 1.91 MB | ||
| ▲ 52 total files | |||
Lynda - Migrating Access Databases to SQL Server
This Course will be good to the Best for DL within 30 days after has been posed, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive.
2h 39m Intermediate Oct 06, 2015 | Uploaded in Feb 19, 2016 by 2boweb
Subject: IT
Software: Access SQL Server
Author: 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
////////////////////////////////////////////////////////////////////
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 164.3 MB | abidmail | 5 years | 0 | 0 | |
| 229.4 MB | abidmail | 5 years | 4 | 5 | |
| 570.6 MB | xHOBBiTx | 7 years | 0 | 0 | |
| 140.8 MB | xHOBBiTx | 8 years | 2 | 1 | |
| 65.09 MB | 2boweb | 10 years | 0 | 0 |
All Comments