How we import access database(.mdb) into sql server 2008 in C#

Question

I used access database in my project. I want to import full data of my database to sql server 2008. How can I do this?

Solution 1

Later versions of Access have an Upsizing Wizerd built-in which will assist you in migrating your Access DB to SQL Server. It's usually under the [Database Tools] menu.

Solution 2

you can use SQL Server Import and Export Wizard, check below link for more information

Importing and Exporting Data by Using the SQL Server Import and Export Wizard

Solution 3

Yes, using the Upsizing Wizard: open Access database, select Tools menu, and then Database Utilities menu. Upsizing utility is not included in default installation of Microsoft Access, so you’ll need to install in order to benefit of it.

What you export is your data, indexes, and defaults. The great thing is that Upgrading Wizard maintains your table relationships and referential integrity after upsizing. Be aware, upsizing operation means only a conversion for you i.e. it won’t take advantage of SQL Server features.

You’ll have some fun converting Access queries to SQL Server views or stored procedures as wizard didn’t make it.