Last post Nov 22, 2007 10:56 PM by chetan.sarode
Nov 22, 2007 04:48 PM|jcsanavi|LINK
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)
Nov 22, 2007 09:48 PM|MaineOne|LINK
The asp tables and stored prcedures are added using the 'aspnet_regsql.exe'
Run that and you should be all set.
Nov 22, 2007 10:56 PM|chetan.sarode|LINK
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.
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.