Skip to content

TechRepublic

  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
Resources
  • TechRepublic Premium
  • TechRepublic Academy
  • Newsletters
  • Resource Library
  • Forums
  • Sponsored
Go Premium
Popular Topics
  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
  • Project Management
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
View All Topics
Go Premium
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

Daily Tech Insider

If you can only read one tech story a day, this is it.

TechRepublic TechRepublic
  • TechRepublic on Facebook
  • TechRepublic on X
  • TechRepublic on LinkedIn
  • TechRepublic on YouTube
  • TechRepublic on Pinterest
  • TechRepublic RSS
Services
  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers
Explore
  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • Editorial Policy
  • Legal Terms
  • Privacy Policy
© 2025 TechnologyAdvice. All rights reserved.
CLOSE

Create a TechRepublic Account

Get the web's best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let's start with the basics.

Already registered? Sign In
Use Facebook
Use Linkedin

* - indicates required fields

CLOSE

Sign in to TechRepublic

Not a member? Create an account
Use Facebook
Use Linkedin

Lost your password? Request a new password

CLOSE

Reset Password

Please enter your email adress. You will receive an email message with instructions on how to reset your password.

Check your email for a password reset link. If you didn't receive an email don't forgot to check your spam folder, otherwise contact support.

Back to login
1 Finish Profile
2 Newsletter Preferences
CLOSE

Welcome. Tell us a little bit about you.

This will help us provide you with customized content.

No thanks, continue without
1 Finish Profile
2 Newsletter Preferences
CLOSE

Want to receive more TechRepublic news?

Newsletter Name
Subscribe
Daily Tech Insider
Daily Tech Insider AU
TechRepublic UK
TechRepublic News and Special Offers
TechRepublic News and Special Offers International
Executive Briefing
Innovation Insider
Project Management Insider
Microsoft Weekly
Cloud Insider
Data Insider
Developer Insider
TechRepublic Premium
Apple Weekly
Cybersecurity Insider
Google Weekly
Toggle All
No thanks, continue without

You're All Set

Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.

Back to Home Page
×