Converting an Access database to SQL

Question

I am a programmer and am wanting to undertake a project of converting an Access database to an SQL database.

Is this pretty easy to do? Can I just use a tool to create all the tables with the same names and 'copy' over the data?

I know that Access has built in reporting features. Does SQL have these reporting features? If not, is it easy to create them?

BizApps · Accepted Answer · 2012-08-15 05:51:53Z

2

You just need to import your access to sql server database.

Check this tutorial:

Importing Microsoft Access 2007 Database Tables into SQL Server

Regards

answered Aug 15, 2012 at 5:51

BizApps

6,1409 gold badges42 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fionnuala · Accepted Answer · 2012-08-15 19:46:59Z

1

MS Access is not a database at all, by default, it uses the Jet or ACE database to store data, but Access will also work perfectly well with data stored in a number of other databases, MS SQL included. There is no need to change from an MS Access front-end when you are moving the tables to a new back-end. SQL Server does not have all the user-interface and reporting tools that MS Access has, it is a database, not "a rapid application database development and reporting tool"

edited Aug 15, 2012 at 19:46

answered Aug 15, 2012 at 13:57

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Comments

hallie · Accepted Answer · 2012-08-15 05:53:18Z

0

Try this one its free from microsoft.

answered Aug 15, 2012 at 5:53

hallie

2,83320 silver badges28 bronze badges

Collectives™ on Stack Overflow

Converting an Access database to SQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related