Recommended UK companies for migrating from Access to SQL
in [Help]
|
From: Andrew on 8 Jul 2010 10:21 On Jul 6, 7:19 pm, "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...(a)gmail.com> wrote: > 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_ke...(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... > > and see alsohttp://www.utteraccess.com- Hide quoted text - > > - Show quoted text - Hi Aaron Thanks for the offer, which I was about to reply to, via email. I'm not sure if you're UK based? If not, this might not work, because as mentioned, I'd want to be involved in the upgrade, and I feel it would be easier to do this if we could meet. However, I was just reading other messages in the group, and, having seen your contributions into the discussion headed "database keeps corrupting", I'm not sure that my clients would be prepared to work with someone who expresses themselves as directly as you, and I don't know that we'd be able to work together constructively. So, thanks for the offer, but I don't think it would work out this time, Regards Andrew
From: Andrew on 8 Jul 2010 10:33 On Jul 6, 5:23 pm, 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- Hide quoted text - > > - Show quoted text - Hi John Many thanks for your input - I'll definitely take a look at these resources. Best regards Andrew
From: Tony Toews on 8 Jul 2010 17:30 On Thu, 8 Jul 2010 07:21:17 -0700 (PDT), Andrew <andrewmrichards(a)yahoo.co.uk> wrote: >However, I was just reading other messages in the group, and, having >seen your contributions into the discussion headed "database keeps >corrupting", I'm not sure that my clients would be prepared to work >with someone who expresses themselves as directly as you, and I don't >know that we'd be able to work together constructively. > >So, thanks for the offer, but I don't think it would work out this >time, Such a polite reply. <smile> Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/
From: a a r o n . k e m p f on 27 Jul 2010 13:48 Andrew; the crybabies on this group try to prevent people from moving to SQL Server. You're asking for someone to help you to move to SQL Server. Thanks -Aaron MCITP: DBA SQL 2005/2008 On Jul 8, 7:21 am, Andrew <andrewmricha...(a)yahoo.co.uk> wrote: > On Jul 6, 7:19 pm, "a a r o n . k e m p f @ g m a i l . c o m" > > > > > > <aaron.ke...(a)gmail.com> wrote: > > 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_ke...(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... > > > and see alsohttp://www.utteraccess.com-Hide quoted text - > > > - Show quoted text - > > Hi Aaron > > Thanks for the offer, which I was about to reply to, via email. I'm > not sure if you're UK based? If not, this might not work, because as > mentioned, I'd want to be involved in the upgrade, and I feel it would > be easier to do this if we could meet. > > However, I was just reading other messages in the group, and, having > seen your contributions into the discussion headed "database keeps > corrupting", I'm not sure that my clients would be prepared to work > with someone who expresses themselves as directly as you, and I don't > know that we'd be able to work together constructively. > > So, thanks for the offer, but I don't think it would work out this > time, > > Regards > Andrew- Hide quoted text - > > - Show quoted text -
First
|
Prev
|
Pages: 1 2 Prev: Recommended UK companies for migrating from Access to SQL Next: Access 2003/Access 2007 |