DDL script for database

Question

User400930632 posted

Hi All,

I downloaded the application and there is a script which allows you to create the database, but the script is not complete. There seem to be objects missing, in specific aspnet_users table. I was hoping to create the database on a MSSQL 2000 version rather than the 2005 express version.

Any suggestions would be much appreciated.

Regards,

 

Terry

Answer 1

User-1061167628 posted

Took me a bit to find this.  Run the following command to create the necessary default database to which you will run the script against to create the necessary tables.

C:\WINNT\Microsoft.Net\Framework\v2.0.50727\aspnet_regsql.exe

**If you are running XP it is C:\Windows\

Answer 2

User400930632 posted

Thanks, thats a bit of a start. But it doesn't solve my TimeTracker problem. For example the script:

ALTER TABLE [dbo].[aspnet_starterkits_TimeEntry] ADD
 CONSTRAINT [FK_TimeTracker_TimeEntry_aspnet_Users] FOREIGN KEY
 (
  [TimeEntryUserId]
 ) REFERENCES [dbo].[aspnet_Users] (
  [UserId]
 ),
 CONSTRAINT [FK_TimeTracker_TimeEntry_IssueTracker_ProjectCategories] FOREIGN KEY
 (
  [CategoryId]
 ) REFERENCES [dbo].[aspnet_starterkits_ProjectCategories] (
  [CategoryId]
 )
GO

What am I to do with the references to aspnet_users?

Regards,

Terry

Answer 3

User-1061167628 posted

I am assuming that it can't find the database with the necessary tables.  Here is what I did on 2 PCs with success.  I apologize if some of this sounds mundane but I want to make sure anyone else viewing this post follow my logic.

 

1- Installed SQL Server Express 2005

2- Installed SQL Server Management Studio Express (http://msdn.microsoft.com/sql/express/)

3- I launched the management studio to insure I could see the default SQL instance

4- I ran aspnet_regsql.exe from C:\Windows\Microsoft.Net\Framework\v2.0.50727\aspnet_regsql.exe

*This installed the database "aspnetdb" with the following tables

dbo.aspnet_Applications

dbo.aspnet_Membership

dbo.aspnet_Paths

dbo.aspnet_PersonalizationAllUsers

dbo.aspnet_PersonalizationPerUser

dbo.aspnet_Profile

dbo.aspnet_Roles

dbo.aspnet_SchemaVersions

dbo.aspnet_Users

dbo.aspnet_UsersInRoles

dbo.aspnet_WebEvent_Events

5- In the Management Studio I opened the script file included with the starter kit (timetracker-add.sql)

6- I selected the aspnetdb in the database selection to the left of Execute

7- Executed the script and it built the following tables in the aspnetdb database

dbo.aspnet_starterkits_ProjectCategories

dbo.aspnet_starterkits_ProjectMembers

dbo.aspnet_starterkits_Projects

dbo.aspnet_starterkits_TimeEntry

 

Hope this helps get it working for you,

-Kirk