The wizard reports no errors, and the forum and the posts are displayed right.  However, I'm not able to add new topics or reply to topics.

 

I get an error msg saying that some column in some table doesn't allow NULL.  I tried to edit the settings for the tables (in MSSQL) that were reported, so that they would accept NULL in the columns mentioned.  This worked well for the first 2-3 tables that had this error-message, until I got a message saying "Illegal use of NULL".

 

Any ideas for solving this ?

 

Btw: The upsizing wizard in Access is not working for me at all, so don't suggest trying that. 

 

I need some hints here:

- What should I set as destination ?  I have used SQL Native Client so far.

- Is it neccecary to fiddle around with the settings for the tables ?

- Can I use WebWiz to set up an empty database, and then fill in only the contents of trhe tables ?   If yes: How do I copy only the contents, and not the settings ?

 

 

I'm going to try that tonight. Will post if I have any sucess.

 

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.

 

Hi boRg,

 

I made this procedure and it was a success !

 

Now , I have a little problem.

 

My Hosting Provider , don´t accept connection via Enterprise Manager, only accept via "ASP.Net Enterprise Manager" - http://mssql.zipweb.com.br/mssql/app/connect.aspx - http://mssql.zipweb.com.br/mssql/app/connect.aspx   , via the Plesk Control Panel.

 

Well, now how I do this migration of the Datas from SQL Local to SQL in the Hosting via this Control Panel ?

 

Thank you very much for your attention.

 

Rodrigo