I have loaded the WebShop database into MSSQL 2000 using the DTSWIZ.exe program for SQLEXPRESS but I can't seem to get the stored procedures to load into the MSSQL 2000 database. Do you know how I can get the webshop database into the MSSQL 2000 database for the Webshop. I can to this will scripts if you have them or if you have a version of the webshop databse for MSSQL 2000. Please let me know.

Hi there,

If you have a running version of the WebShop database in SQL 2005, you can simply script all procedures using SQL Server Management Studio and then run them against SQL 2000.

There might be a few incompatibilities (nvarchar(max) versus ntext, but not much, if any at all......

Imar

Hi Imar,

I did that with the stored procedures but when I ran the program I kept getting an error comlaining the the schema version was at level 1. I'm not sure how to get around that.

Matt

That error is usually caused by the fact there is no data in the aspnet_* tables. Some of those table require some base data to function correctly.
Search your computer (and this forum for info) for a tool called aspnet_regsql. You can use it to configure your database for ASP.NET Services like membership.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

I did run the aspnet_regsql utility but I don't see any data in those table until I import my data using dts.

You can simply copy some existing records into your new database as well....

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004