upgrading Backend Access to SQL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

upgrading Backend Access to SQL

Author

Topic

vbbbmom
Starting Member

4 Posts

Posted - 2013-09-10 : 09:30:10

I am pretty good with Access, but I do not know anything about SQL. We are entertaining the idea of moving our data to a cloud and I need to know how to convert my Access backend DB to SQL. which version of SQL will I need to use to do the conversion and will also work in a cloud environment. I also would like suggestions on SQL hosting services.

Thank you!

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-10 : 09:41:32

One possibility is to "upsize" the Access DB to SQL. It is relatively easy and painless if you follow their guidelines - see here: http://office.microsoft.com/en-us/access-help/move-access-data-to-a-sql-server-database-by-using-the-upsizing-wizard-HA010275537.aspx (for example, you should have a unique index on each table you want to migrate to SQL).

I have never done this with Azure, but I would imagine that the process would be similar. Googling found this: http://blogs.msdn.com/b/ssma/archive/2011/04/13/migrating-access-jet-databases-to-sql-azure.aspx

vbbbmom
Starting Member

4 Posts

Posted - 2013-09-23 : 15:09:00

thank you!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources