From: Andrew on 6 Jul 2010 07:51 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
From: John W. Vinson on 6 Jul 2010 12:23 On Tue, 6 Jul 2010 04:38:53 -0700 (PDT), Andrew <andrewmrichards(a)yahoo.co.uk> wrote: >Hi all > >I have a client for whom I've created an Access database over a period >of some years. > >It's now getting to the point where we're going to have to migrate >this database to SQL Server. This is not something that I have a lot >of experience in, and would therefore like to work with a third-party >company on the project - the idea would be that such a company >provides oversight / suggestions / tools / time / experience and that >I do a fair amount of the work, as (a) I want to learn as much as >possible from the process and (b) moving forward, I'll need to be >supporting the database. > >The database in question has around 130 tables, and (when compacted) >around 400mb of data. It is split between a front end and two separate >back-ends. There is a significant amount of VBA (c 30000 lines) I can't recommend any UK businesses (not being there and not having had any such business relationships), but though this is a big job, it's not at all overwhelming. There are some good resources on the Net, which you should read over just so you can work effectively with whoever you end up hiring; see Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Tony Toews' SQL upgrade FAQ: http://www.granite.ab.ca/access/sqlserverupsizing.htm -- John W. Vinson [MVP] Microsoft's replacements for these newsgroups: http://social.msdn.microsoft.com/Forums/en-US/accessdev/ http://social.answers.microsoft.com/Forums/en-US/addbuz/ and see also http://www.utteraccess.com
From: a a r o n . k e m p f on 6 Jul 2010 14:19 you should contract it out to me, I'm a certified DBA and I've been through a LOT of Access->SQL migrations email me at aaron_kempf(a)Hotmail.com and I'll send you a resume. Thanks -Aaron On Jul 6, 9:23 am, John W. Vinson <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote: > On Tue, 6 Jul 2010 04:38:53 -0700 (PDT), Andrew <andrewmricha...(a)yahoo.co..uk> > wrote: > > > > > > >Hi all > > >I have a client for whom I've created an Access database over a period > >of some years. > > >It's now getting to the point where we're going to have to migrate > >this database to SQL Server. This is not something that I have a lot > >of experience in, and would therefore like to work with a third-party > >company on the project - the idea would be that such a company > >provides oversight / suggestions / tools / time / experience and that > >I do a fair amount of the work, as (a) I want to learn as much as > >possible from the process and (b) moving forward, I'll need to be > >supporting the database. > > >The database in question has around 130 tables, and (when compacted) > >around 400mb of data. It is split between a front end and two separate > >back-ends. There is a significant amount of VBA (c 30000 lines) > > I can't recommend any UK businesses (not being there and not having had any > such business relationships), but though this is a big job, it's not at all > overwhelming. There are some good resources on the Net, which you should read > over just so you can work effectively with whoever you end up hiring; see > > Jeff Conrad's resources page:http://www.accessmvp.com/JConrad/accessjunkie/resources.html > > The Access Web resources page:http://www.mvps.org/access/resources/index.html > > Tony Toews' SQL upgrade FAQ:http://www.granite.ab.ca/access/sqlserverupsizing.htm > > -- > > John W. Vinson [MVP] > Microsoft's replacements for these newsgroups:http://social.msdn.microsoft.com/Forums/en-US/accessdev/http://social.answers.microsoft.com/Forums/en-US/addbuz/ > and see alsohttp://www.utteraccess.com
From: amn on 7 Jul 2010 05:22 On Jul 6, 1:51 pm, Andrew <andrewmricha...(a)yahoo.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 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,
From: Andrew on 7 Jul 2010 10:12 On Jul 7, 10:22 am, amn <angel.m...(a)gmail.com> wrote: > On Jul 6, 1:51 pm, Andrew <andrewmricha...(a)yahoo.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
|
Next
|
Last
Pages: 1 2 Prev: Recommended UK companies for migrating from Access to SQL Next: Access 2003/Access 2007 |