Results 1 to 2 of 2

Thread: upsizing wizard

  1. #1
    Join Date
    Jan 2004
    Posts
    124

    Unanswered: upsizing wizard

    I have several small web applications that use an Access database. A few of the applications are nearing a point to migrate over to a more robust database...i.e. SQL Server. For the most part, most of the databases are very simple. One or two tables used for logins, setting access permissions, collecting data from forms, etc. Some of the tables have relationships, but no stored procedures or advanced query strings. Very basic and simple DB's.

    Can you use the upsizing wizard or any other method to move to a SQL Server DB? If so, can anyone direct me to any tutorials or information on moving an Access DB to MS SQL Server? Any help is appreciated. Thanks in advance.
    -Dman100-

  2. #2
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    88
    When I did my conversion I did the following:

    Enterprise Manager:
    1) Database level >> Action Menu >> New Database ... setup a name
    2) Highlight new database name
    3) Tools Menu >> Data Transformation Services >> Import Data

    Data Source = Microsoft Access

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •