Hello, All!

Recenly I migrated v7.01 Access DB (2002) into MS SQL 2000 SP3 using Access XP Upsize Wizard. Also I prepared user who have "owner" rights on SQL DB.  I used all default options during UPSIZE process...

Next, I try to load my board via WEB and see the error:

Microsoft OLE DB Provider for SQL Server error '80040e14'
Could not find stored procedure 'wwfSpSelectConfiguration'.
/board2/common.asp, line 247


I double checked that I have permissions to SQL DB...Moreover, if I create new DB through msSQL_server_setup.asp - all work fine.

I found at this forum that I "need to run the sql server setup file in the sql server version as you need to create the stored procedures on the sql server". I run msSQL_server_setup.asp and see a lot of errors, but my board start work!!

Could you tell me please, is it normal way to migrate Access->SQL? Should I skip all errors when msSQL_server_setup.asp work?

Thank you in advance!

Best wishes,
Sergey

Thank you! Yes, I didn't say anything about deleting the upsized tables...
Could you tell me please, should I set such parameters or msSQL_server_setup.asp will process already existed DB correctly (with some "normal" error messages)?

Dear All!

Does anyone run msSQL_server_setup.asp after UPSIZE WIZARD? Should I change something in this asp to prepare just migrated DB?

Thank you!!

1. msSQL_server_setup.asp
2. alter all tables
3. Enterprise Manager DTS

Thank you!

Could you tell me please, what I need to alter all tables ?
If I use commands like DELETE FROM or TRUNCATE TABLE for all tables, I got several errors in DTS import - something about "Violation of PRIMARY KEY constraint...Cannot insert duplicate key in object "tblDateTimeFormat" etc

Thank you in advance!

Dear All,

Just found Bruce recommendations about Access->SQL conversion:
http://forums.webwiz.net/forum_posts.asp?TID=580&KW=upsize - http://forums.webwiz.net/forum_posts.asp?TID=580&KW=upsize

One small question - is it normal to see a lot of errors (about existed DBs) when we "run the SQL server setup file to create stored procedures on the SQL server"? Can we relay on such method?

Thank you!

It will show errors if the tables already exsist.

Maybe another way if you are worried about the errors is to first run the SQL setup script, then  delete all the forum tables in the database, then run the upsize wizard. That way you don't have to worry about the error messages that say, 'either an error or the table already exsist'

Thank you very much, Bruce! I'm really happy to get Creator's advice!
I'll just ignore error messages...

>Maybe another way if you are worried about the errors is to first run >the SQL setup script, then  delete all the forum tables in the >database, then run the upsize wizard.

I checked this way - it also work! Only one extra question - should I use "File Data Source (DSN)" or "Machine Data Source" for SQL database? Will I need in some special options during upsize (like "table relations" type or DSN's options?

Thank you in advance,

Best wishes,
Sergey

-boRg- wrote: It will show errors if the tables already exsist. Maybe another way if you are worried about the errors is to first run the SQL setup script, then  delete all the forum tables in the database, then run the upsize wizard. That way you don't have to worry about the error messages that say, 'either an error or the table already exsist'

I can't remeber but both those options will mean that the default values and relationships will not be created. There is another option in the upsize wizard somewhere but I don't remeber how to use it.

You'll just have to mess with it till you find the right options.

Thank you Bruce! I'll check all upsize options...
BTW, I hope that SQL version will be "solid as rock" as the Access version