How To Migrate Ms access 2003 database to MS Sql server2005 database?

arjun13y ago

hi,

Open sql server

Create a new empty database.

Right-click the database in the Object Explorer.

Select Tasks | Import Data... from the context menu.

Change the data source to Microsoft Access.

Browse for the file name.

Click Next...

0

Hi Mahesh..

If u dont mine , where the import option wil be availble in sql server. because am new to this database concepts...

0

YES. SQL Server has an Import feature. In Import, source database, you can select Access and map to your SQL server database.

0