Office Software Thread, moving form access to sql server in Technical; Currently we have a series of 8 databases that are all just .mdb access databases, which basically is our home ...
26th August 2008, 11:49 AM #1
moving form access to sql server
Currently we have a series of 8 databases that are all just .mdb access databases, which basically is our home made reporting system.
Once one round of reporting is completed, the mdbs are archived and replaced with blank ones etc.
The frontend for inputting the data to the databases is done through ASP.
Im wondering if it might be worth as a project changing it so it uses SQL server. Ive never used sql server before (used mysql a bit though) so Im not really sure what things I would need to consider if I was to decide to go down this route.
Would any of the SQL queries in the ASP need changed or would it be a simple case of changing the data sources?
Can sql server import the existing Reports that Ive made in access for the printing of the students' reports?
Would it make archiving each term any simpler?
Basically just looking for some pro's and con's, but Im inclined to think the old 'if it aint broke dont fix it'
IDG Tech News
26th August 2008, 11:52 AM #2
26th August 2008, 03:26 PM #3
Most of the SQL queries will work - you just have to change your connection string - but watch out for the "like" wildcard - it's "*" in Access but "%" in T-SQL
Instead of replacing the databases each time you could just have a year/term/whatever field which you select on - that might just make it easier if ever you want to go back to a previous year etc data. With SQL you don't really have to worry about the size of the file (whereas Access just gets horrible with use)
27th August 2008, 04:20 PM #4
thanks for the replies. I think Im just going to leave it as it is for now.
By the_travisty in forum MIS Systems
Last Post: 29th August 2008, 12:53 PM
By joe90bass in forum How do you do....it?
Last Post: 23rd June 2008, 03:46 PM
By starscream in forum Wireless Networks
Last Post: 6th June 2007, 10:47 PM
By dickyfinn02 in forum MIS Systems
Last Post: 23rd April 2007, 05:33 PM
By tosca925 in forum Windows
Last Post: 22nd November 2006, 02:49 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)