Yet again: Converting from Access to MS-S

 

I used that Blueshell program, but when you try and import the access database into the SQL database, you appear to have to do it table by table, however when you try this it just says that there are bad arguments and I don't know what that means. I look into it and it says that its to do with either invalid table entries or something to do with trying to enter nullable entries into non-nullable fields.

 

Basically people, you have to be an ASP and Database genius to convert Webwiz forums forums from Access to SQL, espically if you don't have access to Enterprise Manager (which appears to be no longer available) on an existing and populated forum.  Which is incredibly frustrating when you are been told not to use Access as it is likely to break down in the future, and I have over 15,000 members - I feel like one day its going to fail and 5 years of hard work will be lost (although I do backup regularly, so something would have to go really wrong) and all I will get is "I told you so", even after hours upon hours of hard work trying to follow the advice to use SQL.

 

I wish somebody would offer a service to convert databases, there are probably many people out there who would pay for such a service, myself including.

 

Also, if anybody does figrue out a way of doing this, which doesn't require a degree in ASP and Databases with software that is currently available, could we have it posted up on webwiz.net as an article to assist current customers.

 

How does that saying go? - I'm stuck between a rock and a hard place.

 

Rant over!

 

Thank you for your continuing hard work...

 

Yes but I can't even get past point 1, as I don't have Enterprise Manager and I don't know of any way to obtain it at the moment. From what I have been told its no longer available.

 

Unfortunetly my techincal abalities, although not complete novice do not extend to been able to transfer these instrution into the SQL Manager Express.