| Author |
 Topic Search  Topic Options
|
balearicjobs 
Groupie
Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 86
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Access to MDF?
Posted: 20 September 2006 at 7:50am |
Not the favoured television home makeover show material but the file.
Does anybody know how to convert an Access database, in this case a V8.4 WWF Access database into an "mdf" file using software currently available on the internet or with Access 2003?
I am trying to convert my forum which currently has 15,000 members (so can't start again) from Access to SQL for performance, secruity and corruption avoidance reasons and Borg mentioned that if you had a mdf file it should be possible to attach this to an SQL database.
|
Thanks for your help!!!
Kind Regards
Rob,
Balearic Jobs
Helping young people find seasonal work in the Balearic Islands, including vacancie
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 September 2006 at 8:35am |
|
You need to be using the DTS tools, try the upsize wizard in Access and have a look at the sticky topic in the version 7.x forum on Access to SQL Server Step by Step
|
|
|
|
balearicjobs
Groupie
Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 86
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 September 2006 at 10:13am |
When you say DTS tools, do you mean something like DTS Soft?
As mentioned in my previous post, I can't follow those instructions as I am unable to get hold of a copy of Enterprise Manager, I don't believe that it's currently available.
|
Thanks for your help!!!
Kind Regards
Rob,
Balearic Jobs
Helping young people find seasonal work in the Balearic Islands, including vacancie
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 September 2006 at 10:35am |
|
The DTS tools are built into Enterprise manager, without this I'm afraid you maybe stuck with Access or start again with a clean install on SQL Server.
|
|
|
|
balearicjobs
Groupie
Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 86
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 September 2006 at 10:56am |
 -boRg- wrote:
The DTS tools are built into Enterprise manager, without this I'm afraid you maybe stuck with Access or start again with a clean install on SQL Server. |
Thats scary. So now Enterprise Manager is apparently not available people will not be able to upgrade from Access to SQL? 
Do you know where its possible to download legally, or purchase Enterprise Manager?
|
Thanks for your help!!!
Kind Regards
Rob,
Balearic Jobs
Helping young people find seasonal work in the Balearic Islands, including vacancie
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 September 2006 at 10:59am |
|
You would need to get SQL Server 2000
|
|
|
|
nexus
Groupie
Joined: 23 May 2005
Status: Offline
Points: 60
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 September 2006 at 11:21pm |
|
Don't think you need to start from scratch again!
Since you're not able to get the enterprise version, couldn't you ask one of the guys in here which have enterprise version to upsize/convert it for you?
I mean, downloading the access db is no problem, so you only have to hand it out then to someone whom you TRUST and then let them run it through the DTS tool for you.
Or am I mistaken somewhere?? =)
Edited by nexus - 20 September 2006 at 11:22pm
|
|
