" MIGRATE MS ACCESS DB TO SQLSERVER DB Table of Contents1. SQL server installation ......................................................................................................... 22. SQL server management studio ......................................................................................... 101 1. SQLserver installation To install the SQL Server click New SQL server stand alone installation or add featuresto an existing installation option from the below window.2 Accept the License terms from the following window and click next.3 The following windows shows the installation of Global Rules.4 In the Feature selection window click the Select All button and click next.5 In the instance Configuration window Select the Default instance option and click next.6 The following window shows the server configuration. Click Next button to continue theinstallation process.7 In the Database Engine Configuration window click the windows authentication mode optionand click next.8 The following window shows the completion of installation process.The click the close button toclose the window.9 2. SQL server management studioStart -> All Programs-> Microsoft SQL server management studio (SSMS).The home page of SSMS Tool is shown in the following window.In connect to server window, Enter the server name and click connect button.Create new database by right clicking on database and select new database.10 In new data base window, enter database name as Access and click OK button.11 New database is created. Then right click on Access.Select tasks and choose import data.12 In the following window, choose a data source as Microsoft Access and specify the MS access file path. Then click nextbutton.13 In the following window, choose a destination as SQL server native client 11.0 and choose thenewly created database. Then click next button.14 Here specifying the table copy or query. Then click next button.15 In the following window, select the source tables and views.Then click next button.16 In the following window, Review data type mapping and click next button.17 In the following window, Run the package and click next button.18 Here the complete wizard to click finish button. 19 Then successfully MS access database is migrated.20 Then open the SQL server management studio, Connect to server and click the newly created database as Access. Then click the tables. Finally you see the migrated tables.File is attached here.21 "