Access to SQL Server
-
Hi, I'm currently developing a large scale ASP .NET application, and so far I've developed it using Access, after research, I don't think Access is going to handle the amount of usage we expect it to get, therefore I'm looking to switch to SQL Server. Is there anyway I can do this seamlessly and quickly? Thanks, Aaron
-
Hi, I'm currently developing a large scale ASP .NET application, and so far I've developed it using Access, after research, I don't think Access is going to handle the amount of usage we expect it to get, therefore I'm looking to switch to SQL Server. Is there anyway I can do this seamlessly and quickly? Thanks, Aaron
Aaron Hudson wrote:
Is there anyway I can do this seamlessly and quickly?
Export Data using Access or Import using SQL Server :-D
-
Aaron Hudson wrote:
Is there anyway I can do this seamlessly and quickly?
Export Data using Access or Import using SQL Server :-D
Is it as straight forward as that? Me = dumb :-O
-
Aaron Hudson wrote:
Is there anyway I can do this seamlessly and quickly?
Export Data using Access or Import using SQL Server :-D
There used to be an SQL Server upsizing wizard that would automatically upgrade from Access to SQL Server. You would then probably want to do some work to make the best use of SQL server but it should work fine without the extra work. Russell
-
Is it as straight forward as that? Me = dumb :-O
thereis another thing u\d need to do and that is to alter the db connection from ur application. SQL Server is not accessed the same way as Access is. but i think it shouldn't be too much of work :) Rocky u cant climb up a ladder with ur hands in ur pockets
-
thereis another thing u\d need to do and that is to alter the db connection from ur application. SQL Server is not accessed the same way as Access is. but i think it shouldn't be too much of work :) Rocky u cant climb up a ladder with ur hands in ur pockets
Yeah I knew about the code change. The scenario is, I don't want to spend a couple of thousand on the full SQL, so what I've heard is that you can use SQL Express (has like a 2gb size limit I think) for now, while the project is small, and then when it brings in money, upgrade to the full. Now the issues are: 1. Does this work / Will I have any issues in changing from Express to the full version? 2. How do I convert Access to SQL Express? (if #1 is ok) Thanks :)
-
Yeah I knew about the code change. The scenario is, I don't want to spend a couple of thousand on the full SQL, so what I've heard is that you can use SQL Express (has like a 2gb size limit I think) for now, while the project is small, and then when it brings in money, upgrade to the full. Now the issues are: 1. Does this work / Will I have any issues in changing from Express to the full version? 2. How do I convert Access to SQL Express? (if #1 is ok) Thanks :)
offcourse it works and importing data is a very simple task i think just make a new database in SQL Server and right click on it > All Tasks> Import data> From data providers select MS Access, then select the Access file, give user name password if necessary and carry on with the wizard... I think that should be it :) Rocky