Problem Schema SQL (timetracker-add.sql)

Question

User1300074552 posted

Hi,

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

Answer 1

User2069888697 posted

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

C:\WINNT\Microsoft.NET\Framework\v2.0.50727

Run that and you should be all set.

 

Answer 2

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.