locked
DDL script for database RRS feed

  • 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

    Sunday, February 19, 2006 8:49 PM

All replies

  • 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\

    Tuesday, February 21, 2006 7:14 PM
  • 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

    Sunday, February 26, 2006 5:11 PM
  • 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
    Monday, February 27, 2006 7:35 PM