dbTalk Databases Forums  

Recommended UK companies for migrating from Access to SQL

comp.databases.ms-access comp.databases.ms-access


Discuss Recommended UK companies for migrating from Access to SQL in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andrew
 
Posts: n/a

Default Recommended UK companies for migrating from Access to SQL - 07-06-2010 , 07:51 AM






Hi all

I have, over the past few years, been developing a datase for a client
in MS Access. The time is now approaching, however, when we will be
looking to migrate it to SQL Server, with an MS Access front end.

As this is not an area in which I have much experience, I am looking
to work with a third-party company who can help with this project by
providing oversight / knowledge / experience / tools / suggestions /
help. I am looking to do much of the work myself, along with such a
company so that (a) I can gain knowledge and experience from the
process, and (b) I am able to provide support to my client on the
migrated system.

As it stands, the database has around 130 tables, and (when compacted)
around 400mb of data. There are around 20 users, of whom about 10 use
it on a fairly constant basis. There is a fairly significant (c 30000
lines) of code, which is properly commented. The database as it stands
is normalised and functions well, but is showing signs of creaking at
the seams and needs to be moved to a platform that supports backups,
isn't prone to corruption, and will allow for more growth.

My question is this - does anyone have any experience of working with
UK companies on such a project? I am looking for recommendations on
such companies. I already have a couple of companies in mind, and have
spoken to a couple of people, but want to get a feel for who's worth
contacting. My client is based in SW London, and I'm in Surrey, so if
companies are in that sort of area, that would be a bonus.

Many thanks for your help!

Andrew

Reply With Quote
  #2  
Old   
amn
 
Posts: n/a

Default Re: Recommended UK companies for migrating from Access to SQL - 07-07-2010 , 05:22 AM






On Jul 6, 1:51*pm, Andrew <andrewmricha... (AT) yahoo (DOT) co.uk> wrote:
Quote:
Hi all

I have, over the past few years, been developing a datase for a client
in MS Access. The time is now approaching, however, when we will be
looking to migrate it to SQL Server, with an MS Access front end.

As this is not an area in which I have much experience, I am looking
to work with a third-party company who can help with this project by
providing oversight / knowledge / experience / tools / suggestions /
help. I am looking to do much of the work myself, along with such a
company so that (a) I can gain knowledge and experience from the
process, and (b) I am able to provide support to my client on the
migrated system.

As it stands, the database has around 130 tables, and (when compacted)
around 400mb of data. There are around 20 users, of whom about 10 use
it on a fairly constant basis. There is a fairly significant (c 30000
lines) of code, which is properly commented. The database as it stands
is normalised and functions well, but is showing signs of creaking at
the seams and needs to be moved to a platform that supports backups,
isn't prone to corruption, and will allow for more growth.

My question is this - does anyone have any experience of working with
UK companies on such a project? I am looking for recommendations on
such companies. I already have a couple of companies in mind, and have
spoken to a couple of people, but want to get a feel for who's worth
contacting. My client is based in SW London, and I'm in Surrey, so if
companies are in that sort of area, that would be a bonus.

Many thanks for your help!

Andrew
Andrew,

Please, look at http://www.upsizing.co.uk/

They have (probably) the best Access to SQL Server upsizing tool and
they are an UK company.

Regards,

Angel,

Reply With Quote
  #3  
Old   
Andrew
 
Posts: n/a

Default Re: Recommended UK companies for migrating from Access to SQL - 07-07-2010 , 10:12 AM



On Jul 7, 10:22*am, amn <angel.m... (AT) gmail (DOT) com> wrote:
Quote:
On Jul 6, 1:51*pm, Andrew <andrewmricha... (AT) yahoo (DOT) co.uk> wrote:





Hi all

I have, over the past few years, been developing a datase for a client
in MS Access. The time is now approaching, however, when we will be
looking to migrate it to SQL Server, with an MS Access front end.

As this is not an area in which I have much experience, I am looking
to work with a third-party company who can help with this project by
providing oversight / knowledge / experience / tools / suggestions /
help. I am looking to do much of the work myself, along with such a
company so that (a) I can gain knowledge and experience from the
process, and (b) I am able to provide support to my client on the
migrated system.

As it stands, the database has around 130 tables, and (when compacted)
around 400mb of data. There are around 20 users, of whom about 10 use
it on a fairly constant basis. There is a fairly significant (c 30000
lines) of code, which is properly commented. The database as it stands
is normalised and functions well, but is showing signs of creaking at
the seams and needs to be moved to a platform that supports backups,
isn't prone to corruption, and will allow for more growth.

My question is this - does anyone have any experience of working with
UK companies on such a project? I am looking for recommendations on
such companies. I already have a couple of companies in mind, and have
spoken to a couple of people, but want to get a feel for who's worth
contacting. My client is based in SW London, and I'm in Surrey, so if
companies are in that sort of area, that would be a bonus.

Many thanks for your help!

Andrew

Andrew,

Please, look athttp://www.upsizing.co.uk/

They have (probably) the best Access to SQL Server upsizing tool and
they are an UK company.

Regards,

Angel,- Hide quoted text -

- Show quoted text -
Hi Angel

Thanks for your thoughts - yes, this is one of the companies I've been
talking to, as I've met Andy Couch at various conferences.... I
definitely think he'd be able to help, but I thought it made sense to
look around for other options before making a decision.

Thanks, though.

Andrew

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.