dhapp
asked on
Migrating from MS Access to SQL server
I need some coaching in how to get started with SQL.
I would like to migrate an Ms Access database to SQL for hosting on the web.
The application currently works with the Ms Access backend but I've been told that it will be sturdier if the tables are converted to SQL.
I don't know where to start.
I have looked on the web and know that this is an expensive product, but there seem to be a variety of versions from Express which is free but has limitation; I can't tell from what I have read whether express will work for my application.
I'm looking for someone who will have an exchange of postings so that I can figure out what I need to get and where to go from there.
I would like to migrate an Ms Access database to SQL for hosting on the web.
The application currently works with the Ms Access backend but I've been told that it will be sturdier if the tables are converted to SQL.
I don't know where to start.
I have looked on the web and know that this is an expensive product, but there seem to be a variety of versions from Express which is free but has limitation; I can't tell from what I have read whether express will work for my application.
I'm looking for someone who will have an exchange of postings so that I can figure out what I need to get and where to go from there.
ASKER
I looked at the article and what I think that I got from it is that the data conversion is possible.
What I have to weight is the difficulty that you mention versus the price of SQL standard version (approx $1400). Why isn't there something more reasonably priced?
I'm not sure if this is relevant: the app that I have built will be hosted on the web and may get a a large number of hits in the first few minutes that it is available (perhaps 100 hits).
If I were to get SQL Express and could import the data would the resulting backend support the stress of the many hits?
What I have to weight is the difficulty that you mention versus the price of SQL standard version (approx $1400). Why isn't there something more reasonably priced?
I'm not sure if this is relevant: the app that I have built will be hosted on the web and may get a a large number of hits in the first few minutes that it is available (perhaps 100 hits).
If I were to get SQL Express and could import the data would the resulting backend support the stress of the many hits?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good,
So I have downloaded SQL Express and am trying to install it.
I found the SQL Server Installation Center and clicked on the System Configuration Checker with shows a dialogue box to Browse For Folder
I can't figure out which folder to choose. I have tried many different folders and continue to get the Error box that indicates "C:\WhateverFolderIsSelect
Can you help? (see attached graphics)
SQLExp2.JPG
So I have downloaded SQL Express and am trying to install it.
I found the SQL Server Installation Center and clicked on the System Configuration Checker with shows a dialogue box to Browse For Folder
I can't figure out which folder to choose. I have tried many different folders and continue to get the Error box that indicates "C:\WhateverFolderIsSelect
Can you help? (see attached graphics)
SQLExp2.JPG
There is one problem though, you are talking about SQL Express, which comes with none of the above mentioned import/export functionality, making the job of migrating potentially alot more difficult.
You should look at this article: http://blogs.msdn.com/euanga/archive/2006/07/20/672272.aspx