[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

Advice on Migrating from Access to Another RDMS

Hi,

I've been using Access for the past 3 years.  I am not able to design the forms because I am not a programmer but I really like the query interface. And I understand the logic of the relationships and can design the tables and relationships, and have a good idea of what is needed in order to get the product that I need.

So, in short, I wouldn't be designing the UI but I would be managing all the data and doing the data analysis, creating reports, etc.  And I would be able to work with the programmers to explain what we needed.

My question is: What is the next logical progression to move to if I wanted to migrate our data from Access to another RDMS?

Thanks,
Kannika
0
kannika
Asked:
kannika
  • 2
2 Solutions
 
hnasrCommented:
Using Access at the moment, suggest MSSQL server for data and using access as a User Interface.
I tried Access as a user interface to mange data in Oracle database.

In general, you need to study the options:
Set up your requirement list.
List properties of a suggested database.
List properties of current database.
Match your requirements with what other databases can offer.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Agree with hnasr that Microsoft SQL Server is the next logical choice. You can use the Express editions, which are free, to begin your learning process. Here's the 2008 download page:

http://www.microsoft.com/en-us/download/details.aspx?id=1695

Be sure to also install Management Studio, which is the visual environment you can use to manage your SQL Server and databases:

http://www.microsoft.com/en-us/download/details.aspx?id=7593

Moving from Access to other platforms (especially MSSQL Server) is fairly straight forward, and MSFT has provided a Migration Assistant:

http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#

That's the nuts-and-bolts of the process, but there are many other factors to consider. For example, will you leave your queries in Access, or will you move them to SQL Server as Views? How much processing will be moved to Stored Procedures or Triggers? There's no way for us to advise you on that, other than to say that, for the most part, the more you can put on the server, the better off you are.

Here's some more information about moving to SQL Server:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp - The Best of Both Worlds
http://www.databasejournal.com/features/msaccess/migrating-access-databases-to-sql-server.html
http://www.fmsinc.com/microsoftaccess/SQLServerUpsizing/index.html
0
 
dzaldivarCommented:
I have converted many Access 2007 Databases to SQL Server using the  wizard provided by Microsoft and it has worked like a champ. The only issue is the version of Access to SQL Server that you are converting too.

Dave
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I've never been a fan of the upsizing wizards provided directly in Access, and in fact many people have significant issues with them (indexes not converting, queries malformed, etc etc)  - but to each his own, I suppose.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now