Problem Schema SQL (timetracker-add.sql) RRS feed

  • Question

  • User1300074552 posted


    I'm install the Time Tracker and need transfer the DataBase Sql 2005 Express to Sql 2000.

    In the file timetracker-add.sql don't have the all structre DB in this file, I'm not see the next tables:

    apnet_Applications, apnet_Membership, apnet_Roles, apnet_SchemaVersion, apnet_Users, apnet_UsersInRoles.

    I'm not understand, How create the schema? in the Sql 2005 Express don't have the "Generate SQL Scripts" for the "Enterprise Manager"

    Help Meeeeeeeeeeeeeeeee!  (Im have 3 day's in this problem)

    Cristobal Sanchez

    Thursday, November 22, 2007 4:48 PM

All replies

  • User2069888697 posted

    The asp tables and stored prcedures are added using the 'aspnet_regsql.exe'


    Run that and you should be all set.


    Thursday, November 22, 2007 9:48 PM
  • User555306248 posted

    1) in VWD create a new Web Site and point it directly to your IIS local web server call it TimeTracker e.g. http://localhost/TimeTracker (since I have problem getting VWD web server to work using the Beta release) this step will create a web site on your local IIS, you can do this manually too.
    2) Unzip the file downloaded into the C:\Inetpub\wwwroot\TimeTracker and overwrite any files there.
    3) Launch the site in IE e.g. http://localhost/TimeTracker/Default.aspx

    Check in web.config for connectionString, configure it according to your server name, password etc.

    In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..

    You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt

    aspnet_regsql, it will open one window, where you  have to configure DB.

    Hope it will help you, let me know.

    Thursday, November 22, 2007 10:56 PM