Results 1 to 5 of 5

Thread: Access database upgrade to SQL Server 2005

  1. #1
    Join Date
    Feb 2010
    Posts
    178

    Access database upgrade to SQL Server 2005

    Hi all,

    I am database administrator in one company, My company is using the database as a MS access. But now they are planning to upgrade the database to SQL server 2005 without any loss of data. anybody have any idea about this. Please reply. Thanks in advance.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,948

    How to Access will be upgrade to SQL Server 2005

    You need to configure Data Source for upgrade. Steps are follows :

    1. In the Control Panel Administrative Tools Select 'Data Source', in the pop-up page select 'User DSN' .
    2. Click next to 'Add' button in the pop-up page select 'Driver do Microsoft Access (*. mdb)', then click on 'complete'.
    3. In the pop-up 'ODBC Microsoft Access install' page, in the 'Data Source Name' text input box, fill in a name, 'description' text box do not enter. Then click on the 'options' button, select the Access file is located in the path.

    Check and reply.

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    re: Access database upgrade to SQL Server 2005

    For the upgrade to SQL Server 2005 from MS access, you also need the select 'User DSN' tab in the 'user data source' under the more you have just added the data source, the name is just fill in the 'Data Source Name'. Then click 'Cancel' to exit the page. Then the data source configuration completed. Check and reply, if you found any issue. Best of luck.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    re: Access database upgrade to SQL Server 2005

    You need to do the the original program references in a database. Follow the steps :
    1. In the 'Start' menu, open the 'Microsoft SQL Server 2005 → SQL Server Management Studio'.
    2. Create a database with the name of the custom, select the new database, right-click select 'task > Import Data'.
    3. In the pop-up page click on Next, 'Data Source' Select 'Microsoft Access', then choose the path where the Access database, if the Access database, a user name and password to fill in, if not do not have to fill out. Click 'Next'.and click OK.
    Check and reply.

  5. #5
    Join Date
    May 2008
    Posts
    2,297

    How to Access will be upgrade to SQL Server 2005

    You can seen in the pop-up page, 'data source' can not move the default security. 'Server Name' and 'authentication' and login to the server and authenticate the same. In the following drop-down box to select the new database, the database if not a new database, click the Refresh button on the back. If you still did not check the server name 'and' authentication 'is correct. You can click on the back of the 'new'. Click 'Next'. In the pop-up page, choose the first one by default to copy one or more table or view data. Click 'Next'. In the 'Select the source table and source view' page, select the tables and views you want to import. You can click 'Preview' view the data in the table and Click 'Next'.By default 'immediate implementation', click 'Next'.Click on the 'complete'. Best of luck.

Similar Threads

  1. Exclusive Access to a SQL Server Database
    By Deward in forum Software Development
    Replies: 3
    Last Post: 20-11-2010, 05:00 AM
  2. Replies: 3
    Last Post: 20-05-2009, 01:03 PM
  3. How to restore database in SQL Server 2005
    By Mahendra varma in forum Software Development
    Replies: 3
    Last Post: 02-05-2009, 01:10 PM
  4. Replies: 3
    Last Post: 20-02-2009, 02:33 AM
  5. Upgrade fails: SQL Server Express 2005 to SQL Server 2005
    By Steve BB in forum Small Business Server
    Replies: 3
    Last Post: 11-06-2008, 07:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,652,911,005.85300 seconds with 17 queries