View Single Post
  #2 (permalink)  
Old May 15th, 2006, 12:06 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,035, Level: 100
Points: 72,035, Level: 100 Points: 72,035, Level: 100 Points: 72,035, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,079
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi Andyw,

Did you only script the structure of the tables, views, stored procedures etc? Or did you also copy over the data?

The aspnet_SchemaVersions data contains a number of important records. It holds the version number of the present schema in the database for each feature that uses that database. This schema table is used to make future upgrades easier.

Whenever a feature is started up, it checks the schema version table to see if that database has a compatible schema. In your case, this table may be empty, and thus you get the error you see...


HtH,

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