Skip to content

TechRepublic

  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • TechRepublic Premium
  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Data Management

Use DTS to Migrate an Access Database to MSDE

By carareynolds June 15, 2006, 1:35 AM PDT

Image
1
of 9

1DTS_Select.JPG
1DTS_Select.JPG
Use DTS to Migrate an Access Database to MSDE

Use DTS to Migrate an Access Database to MSDE

Use DTS to Migrate an Access Database to MSDE

With an aging homebrew helpdesk system increasingly experiencing speed and usability issues, database admins on a budget ($0) find a simple, affordable, and effective solution by using Microsoft Data Transformation Services (DTS) to migrate the backend Access database to Microsoft Data Engine (MSDE). This gallery shows you the migration process.

Use DTS to Migrate an Access Database to MSDE

Select DTS

Select DTS

This screenshot shows the selection of DTS as the data migration tool. You will go to Tools -> Data Transformation Services -> Import Data in SQL Enterprise manager to access the DTS Wizard.

Use DTS to Migrate an Access Database to MSDE

Select Data Source

Select Data Source

In the first screen, you will select the source you want to import your data from. For this exercise, we will be converting from MS Access to SQL so we will select Microsoft Access as the Data Source.

Use DTS to Migrate an Access Database to MSDE

Create New SQL Database

Create New SQL Database

You may need to import your data into a new SQL database. You can create a new database within the wizard by selecting NEW from the database dropdown list.

Use DTS to Migrate an Access Database to MSDE

Select Data to Copy

Select Data to Copy

Within the wizard you will be prompted for the data to copy. You can select all by using the Select All button, or manually check the tables. You can also change the destination tables of the data, or specify specific transformations of the data.

Use DTS to Migrate an Access Database to MSDE

Prepare the Copy

Prepare the Copy

You will be offered the offered the choice of using the GUI tool to select the data you wish to transform, or you can use a T-SQL query to specify the data transformation.

Use DTS to Migrate an Access Database to MSDE

Run or Schedule

Run or Schedule

You will then be prompted to Run the transformation, schedule it to run later, save the package to be executed later, or a combination of all of these.

Use DTS to Migrate an Access Database to MSDE

Run DTS

Run DTS

While DTS is running you will be able to view the tables that are completed, and the amount of data that has been transformed in each.

Use DTS to Migrate an Access Database to MSDE

Tables in SQL

Tables in SQL

After the wizard is complete, you will be able to view your new tables via SQL Enterprise Manager, or by any other method of D.B. access you use.

  • Data Management
  • Account Information

    Share with Your Friends

    Use DTS to Migrate an Access Database to MSDE

    Your email has been sent

Share: Use DTS to Migrate an Access Database to MSDE
Image of carareynolds
By carareynolds
Cara Reynolds an editor on TechRepublic's content team. She has been working in educational, licensed, and Web publishing for more years than she cares to admit and hosts the Right Tool for the Job blog on TechRepublic.
  • Account Information

    Contact carareynolds

    Your message has been sent

  • |
  • See all of carareynolds's content

TechRepublic Premium

  • TechRepublic Premium

    Google Docs tips for advanced users

    None of these tips from TechRepublic Premium require a paid Google Workspace account, so anyone should be able to make use of them. You do, of course, need to have a Google account. From the guide: HOW TO PASTE WITHOUT FORMATTING I use this tip all the time. When you copy and paste text into ...

    Downloads
    Published:  June 8, 2023, 4:00 PM EDT Modified:  June 9, 2023, 8:04 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Google Chrome: Security and UI tips you need to know

    Google’s Chrome web browser held a 64.92% command of the global browser market share in April 2023. That means more users are working with Chrome in significantly more use cases: mobile, desktop and even business. Because of that, users of all types must employ Chrome with a measure of caution and intelligence. After all, most ...

    Downloads
    Published:  June 7, 2023, 4:00 PM EDT Modified:  June 8, 2023, 9:12 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Ergonomics policy

    A safe and healthy work environment provides the foundation for all employees to be at their most productive. Not only does it promote productivity in the workforce, but it also helps prevent accidents, lawsuits and, in extreme cases, serious injury and loss of life. A clear and robust ergonomic policy, like this one from TechRepublic ...

    Downloads
    Published:  June 7, 2023, 4:00 PM EDT Modified:  June 8, 2023, 7:58 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Enterprise IoT calculator: TCO and ROI

    Internet of Things devices serve a number of useful applications, such as environmental, asset or inventory monitoring/control, security functions, fitness devices and smartwatches. There is an array of IoT functions for both consumer and business purposes, but determining the total cost of ownership and the return on your enterprise investment in a widespread or large-scale ...

    Downloads
    Published:  June 6, 2023, 4:00 PM EDT Modified:  June 7, 2023, 9:15 AM EDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice