Access database upgrade to SQL Server 2005

[Umberto-Micro]

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.

[Praetor]

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.

[Katty]

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.

[kelfro]

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.

[Zecho]

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.