+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199

    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'

  2. #2
    My220x's Avatar
    Join Date
    Feb 2008
    Location
    UK
    Posts
    257
    Thank Post
    9
    Thanked 3 Times in 3 Posts
    Blog Entries
    8
    Rep Power
    14
    http://www.microsoft.com/technet/pro...migration.mspx

    Tells you about migrating to sql server from access

  3. #3

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123
    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)

  4. #4

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,512
    Thank Post
    1,320
    Thanked 469 Times in 306 Posts
    Blog Entries
    6
    Rep Power
    199
    thanks for the replies. I think Im just going to leave it as it is for now.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS SQL access and capita problems
    By the_travisty in forum MIS Systems
    Replies: 6
    Last Post: 29th August 2008, 11:53 AM
  2. Web based questionnaire to Access/SQL express dB
    By joe90bass in forum How do you do....it?
    Replies: 4
    Last Post: 23rd June 2008, 02:46 PM
  3. Dell server form factor. Please advise!
    By starscream in forum Wireless Networks
    Replies: 7
    Last Post: 6th June 2007, 09:47 PM
  4. Refreshing MS Access linked tables to CMIS MS SQL
    By dickyfinn02 in forum MIS Systems
    Replies: 0
    Last Post: 23rd April 2007, 04:33 PM
  5. Moving Exchange form one server to another
    By tosca925 in forum Windows
    Replies: 10
    Last Post: 22nd November 2006, 01:49 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •