akc migration: local tomcat details

satya - Wednesday, February 15, 2012 2:14:14 PM

Tomcat service name


Apache Tomcat Tomcat664

satya - Wednesday, February 15, 2012 2:17:36 PM

Tomcat directory


C:\satya\i\tomcat6035_64

satya - Wednesday, February 15, 2012 2:18:45 PM

Sql Server Service names


SQL Server (SQL Experess)
SQL Server (Browser)

Both need to be started.

satya - Wednesday, February 15, 2012 2:21:56 PM

what port are you waiting on?


8080

satya - Wednesday, February 15, 2012 2:27:12 PM

what is the url to test delete folder


http://localhost:8080/display?url=DeleteFolderURL
&folderId=62&ownerUserId=satya

satya - Wednesday, February 15, 2012 2:31:17 PM

what is the url to test delete folder


http://localhost:8080/display?url=DeleteFolderURL
&folderId=62&ownerUserId=satya

satya - Wednesday, February 15, 2012 2:31:54 PM

My local favorites folder is


favories/ai

satya - Monday, February 20, 2012 9:23:37 AM

Next steps


Tune the page
Implement change folder name
Implment folder security

satya - Monday, February 20, 2012 9:27:18 AM

on the del folder page: page links


go to titles view of folder
go to manage this folder
change title for this folder

satya - Wednesday, February 22, 2012 10:27:37 AM

also test the log features

also test the log features

satya - Friday, February 24, 2012 1:41:00 PM

Fix save note

Fix save note

satya - Friday, February 24, 2012 2:08:49 PM

Can I do checkpoint in sql server

Can I do checkpoint in sql server

satya - Friday, February 24, 2012 2:29:06 PM

password for sql server express


sa/sa

satya - Friday, February 24, 2012 2:30:56 PM

where is my backup for sql-server


data\data\akc-data-backups-only\sql-server\test-database
test-database.bak

satya - Friday, February 24, 2012 2:32:49 PM

here is my database configuration


Database.name = akcSqlServerReportsDB
Database.akcSqlServerReportsDB.jdbc_driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
Database.akcSqlServerReportsDB.connection_string =jdbc:sqlserver://localhost\\sqlexpress;database=test
Database.akcSqlServerReportsDB.userid=satya
Database.akcSqlServerReportsDB.password=satya1234
Database.akcSqlServerReportsDB.expirationTimeInMin=5
Database.akcSqlServerReportsDB.minimumNumberOfConnections=5

satya - Saturday, February 25, 2012 9:42:33 AM

Fix double quotes problem in feedback page

Fix double quotes problem in feedback page

satya - Saturday, February 25, 2012 12:09:59 PM

eliminate log


Info:mp:tophalf:

arguments in to the statement are :

Trace:RSDataRowIterator/gotoNextRow Go to next row called
Trace:GT5/gotoNextRow Go to next row called

satya - Friday, March 02, 2012 3:33:18 PM

Refresh the new database


Copy server access database to local
Create a new database
import
fix auto indexes
test locally
backup
restore on server
test on server

satya - Friday, March 02, 2012 3:35:09 PM

Final move


copy akc-sqlserver to akc-sqlserver-prod
have tomcat-prod point to akc-sqlserver-prod
Test

satya - Friday, March 02, 2012 3:36:13 PM

Backout strategy


have tomcat-prod point to akc back again
Do this
  server-sqlserver.conf
  server-accessdb.conf
  server.conf

satya - Tuesday, March 06, 2012 3:52:34 PM

wow!!! is it working. This is on sql server now!

wow!!! is it working. This is on sql server now!

satya - Tuesday, March 06, 2012 3:53:08 PM

cool!! indeed!!

cool!! indeed!!

satya - Tue Nov 06 2012 09:17:49 GMT-0500 (Eastern Standard Time)

Name of the program: Sql Server Management Studio

Name of the program: Sql Server Management Studio

satya - Tue Nov 06 2012 09:18:07 GMT-0500 (Eastern Standard Time)

Users available


sa/sa
satya/satya1234

satya - Tue Nov 06 2012 09:18:23 GMT-0500 (Eastern Standard Time)

Datatbases available


test
akc_prod

satya - 5/15/2014 5:37:36 AM

Chrome menu to test local


local-aspire

satya - 5/15/2014 5:37:54 AM

local akc password


simple1_LL
satyakomatineni.com