Recommended UK companies for migrating from Access to SQL

[Andrew]

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)

 

[John W. Vinson]

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

 

[a a r o n . k e m p f]

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 (e-mail address removed) and I'll send you a resume.

Thanks

-Aaron

 

[Andrew]

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 (e-mail address removed) and I'll send you a resume.

Thanks

-Aaron






- 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

 

[Andrew]

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/Fo...al.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

 

[Tony Toews]

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/

 

[a a r o n . k e m p f]

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