sql server migration
satya - Friday, December 30, 2011 2:58:17 PM
ms sqlserver download
ms sqlserver download
satya - Friday, December 30, 2011 3:11:12 PM
Download sql server express from here
satya - Friday, December 30, 2011 3:22:18 PM
userid/password for now
admin/admin1234
satya - Friday, December 30, 2011 3:59:58 PM
cannot connect to SQL Server (SQLEXPRESS)
cannot connect to SQL Server (SQLEXPRESS)
satya - Friday, December 30, 2011 4:04:03 PM
what a freaking bogus system. Use this as your name
(local)\sqlexpress
use windows nt authentication
satya - Friday, December 30, 2011 4:20:28 PM
Import access database into sql server express
Import access database into sql server express
satya - Friday, December 30, 2011 4:40:16 PM
You can use the manager directly
Create a database of your own
right click on database
tasks
import
pick the ms-access
pick the file
On you go...
satya - Friday, December 30, 2011 9:08:06 PM
where is jdbc driver for sql server express?
where is jdbc driver for sql server express?
satya - Friday, December 30, 2011 9:14:00 PM
This is an interesting post on sql and azure and cloud for java
This is an interesting post on sql and azure and cloud for java
satya - Friday, December 30, 2011 9:16:41 PM
Here is from the source msdn on jdbc
satya - Friday, December 30, 2011 9:18:54 PM
you can also download the driver from that link
you can also download the driver from that link
satya - Friday, December 30, 2011 9:22:47 PM
here is how you build the connection string
satya - Friday, December 30, 2011 9:39:41 PM
an example in my system
Database.name =MyOracleDB
Database.eawd.jdbc_driver =oracle.jdbc.driver.OracleDriver
Database.eawd.connection_string =jdbc:oracle:thin:@host:port:oracle_instance
Database.eawd.userid =user
Database.eawd.password =passwd
satya - Monday, January 02, 2012 10:31:49 AM
what is the jdbc driver classname for microsoft jdbc 3.0 driver?
what is the jdbc driver classname for microsoft jdbc 3.0 driver?
Search for: what is the jdbc driver classname for microsoft jdbc 3.0 driver?
satya - Monday, January 02, 2012 10:34:35 AM
How can I pass userid and password that is not a windows userid/password?
How can I pass userid and password that is not a windows userid/password?
satya - Monday, January 02, 2012 10:37:21 AM
How can I login using a non windows password into sql server?
How can I login using a non windows password into sql server?
satya - Monday, January 02, 2012 10:38:28 AM
How can I choose a database through connection string for a user: ms jdbc driver?
How can I choose a database through connection string for a user: ms jdbc driver?
Search for: How can I choose a database through connection string for a user: ms jdbc driver?
satya - Tuesday, January 03, 2012 10:29:09 AM
My temporary userid password for the sql express database
satya
satya1234
satya - Tuesday, January 03, 2012 10:30:22 AM
How can I change my own password for this user?
Go to sql manager. Goto your user properties. Retype password and confirm password fields.
I don't know what it means to retype old password.
satya - Tuesday, January 03, 2012 10:31:33 AM
what is the default sqlserver sa password?
what is the default sqlserver sa password?
satya - Tuesday, January 03, 2012 10:37:50 AM
There are a variety of schools of though on this
some one says it is blank. some one says it is not. but you can change this by logging in to the sql manager studio and retyping a new password for "sa"
satya - Tuesday, January 03, 2012 10:41:15 AM
you can also change the default database in the user profile
sql manager studio
security
login
your-user
properties
default database
pick your database
satya - Tuesday, January 03, 2012 10:50:11 AM
Various microsoft data sources are listed here
satya - Tuesday, January 03, 2012 10:50:53 AM
These data sources are
com.microsoft.sqlserver.jdbc.SQLServerDataSource
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
com.microsoft.sqlserver.jdbc.SQLServerXADataSource
satya - Tuesday, January 03, 2012 10:52:07 AM
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
Search for: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
satya - Tuesday, January 03, 2012 10:52:30 AM
about jdbc connection pool data sources
about jdbc connection pool data sources
satya - Tuesday, January 03, 2012 11:20:20 AM
satya komatineni ConnectionPoolConnectionManager5
satya komatineni ConnectionPoolConnectionManager5
Search for: satya komatineni ConnectionPoolConnectionManager5
satya - Tuesday, January 03, 2012 3:44:34 PM
How can I control what ports sql server listens on: an msdn article
How can I control what ports sql server listens on: an msdn article
satya - Tuesday, January 03, 2012 3:50:00 PM
sqljdbc.jar or sqljdbc4.jar
sqljdbc.jar or sqljdbc4.jar
satya - Tuesday, January 03, 2012 3:53:20 PM
Here is how you choose one or the other
satya - Tuesday, January 03, 2012 3:53:59 PM
for jdk 6.0 and above use sqljdbc4.0
this jar supports JDBC 4.0 standards.
satya - Tuesday, January 03, 2012 3:54:31 PM
For JDK 1.5 and below use the sqljdbc.jar
which supports jdbc 3.0 standard.
satya - Tuesday, January 03, 2012 3:55:18 PM
I seem to have jdk 16 (which is 6)
I seem to have jdk 16 (which is 6)
satya - Thursday, January 05, 2012 9:18:06 PM
Main steps to test the sql server migration
copy akc as akc2
update server.xml
point /akc to /akc2
point / to /akc2
change database.properties
use sqlserver database connection
userid and password.
place the sql server jdbc jar file
satya - Thursday, January 05, 2012 9:19:58 PM
Here is how you control the tomcat memory and which jdk to use
Here is how you control the tomcat memory and which jdk to use
satya - Thursday, January 05, 2012 9:37:06 PM
Here is a sample entry in conf/server.xml
<Host name="localhost" appBase="webapps"
unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false">
<Context path="" docBase="c:/satya/data/codebase/webapps/akc" debug="0"/>
<Context path="/akc" docBase="c:/satya/data/codebase/webapps/akc" debug="0"/>
</Host>
satya - Thursday, January 05, 2012 9:52:30 PM
The database to akc is defined in database.properties
Database.name = akcReportsDB
Database.akcReportsDB.jdbc_driver=sun.jdbc.odbc.JdbcOdbcDriver
Database.akcReportsDB.connection_string=jdbc:odbc:akc-reportsDB
Database.akcReportsDB.userid=test
Database.akcReportsDB.password=test
Database.akcReportsDB.expirationTimeInMin=5
Database.akcReportsDB.minimumNumberOfConnections=5
The expected odbc name is "ack-reportsDB"
satya - Thursday, January 05, 2012 9:55:52 PM
where can I find about the jdbc sql server driver name for a connection
where can I find about the jdbc sql server driver name for a connection
satya - Thursday, January 05, 2012 10:03:37 PM
Here is the example at that url
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String connectionUrl =
"jdbc:sqlserver://localhost;database=AdventureWorks;"
Connection con = DriverManager.getConnection(connectionUrl);
satya - Thursday, January 05, 2012 10:25:43 PM
here is an example for sql server for akc
Database.name = akcSqlServerReportsDB
Database.akcSqlServerReportsDB.jdbc_driver=\
com.microsoft.sqlserver.jdbc.SQLServerDriver
Database.akcSqlServerReportsDB.connection_string =\
jdbc:sqlserver://localhost;database=test
Database.akcSqlServerReportsDB.userid=satya
Database.akcSqlServerReportsDB.password=satya1234
Database.akcSqlServerReportsDB.expirationTimeInMin=5
Database.akcSqlServerReportsDB.minimumNumberOfConnections=5
#*************************************************
#********** Database aliases
#*************************************************
Database.alias.ptrDB = accessDB
#Database.alias.reportsDB = akcReportsDB
Database.alias.reportsDB = akcSqlServerReportsDB
satya - Friday, January 06, 2012 8:53:41 AM
where can I find tomcat service log files such as stdout and stderr
where can I find tomcat service log files such as stdout and stderr
/tomcat-install-root/logs
satya - Friday, January 06, 2012 8:59:15 AM
tomcat 7 class not found org.apache.xerces.readers.StringReader
tomcat 7 class not found org.apache.xerces.readers.StringReader
Search for: tomcat 7 class not found org.apache.xerces.readers.StringReader
satya - Friday, January 06, 2012 10:26:35 AM
taglib definition not consistent with specification version
taglib definition not consistent with specification version
Search for: taglib definition not consistent with specification version
satya - Friday, January 06, 2012 10:31:35 AM
looks like tomcat7 uses Servlet 2.5 spec
Not sure what that means for porting or tag libraries that are used. Or may be I go back to tomcat6??
satya - Friday, January 06, 2012 10:33:48 AM
On the server I am using tomcat6. May be I will just stick with that one! for now.
On the server I am using tomcat6. May be I will just stick with that one!
satya - Friday, January 06, 2012 10:45:43 AM
Here is one good link when I do decide to migrate to tomcat 7
Here is one good link when I do decide to migrate to tomcat 7
satya - Friday, January 06, 2012 11:27:13 AM
Ok, progress (some) finally
I am able to run tomcat6 running akc. I was able to avoid xml errors and taglib errors.
The latest error is the database refusing connection. I will debug and see whats going on.
Sure progress so far.
satya - Friday, January 06, 2012 11:44:15 AM
sql server express localhost jdbc connection refused
sql server express localhost jdbc connection refused
Search for: sql server express localhost jdbc connection refused
satya - Friday, January 06, 2012 1:49:08 PM
Here is a link that will force sql server to wait on port 1433
Here is a link that will force sql server to wait on port 1433
looks like by default it waits on any dynamic port. you have to disable that and then enable a specific port.
satya - Friday, January 06, 2012 1:51:10 PM
Suggested instructions
sql server configuration manager
nework configuration
protocols
tcp/ip : enable
right click properties
go to ip addresses tab
go to the bottom to see "ip all"
put a blank in "dynamic ip"
put a speciific port as 1433
stop and start sql server service
satya - Friday, January 06, 2012 2:00:57 PM
It should be 1434
It should be 1434
satya - Friday, January 06, 2012 2:01:30 PM
where is the sql server express log file located?
where is the sql server express log file located?
Search for: where is the sql server express log file located?
satya - Friday, January 06, 2012 2:53:53 PM
looks like SQL Server browser service have to be up and running
After I did this I am able to create a jdbc connection. I am almost getting there.
satya - Friday, January 06, 2012 3:50:43 PM
problems with keyword public in sql server
problems with keyword public in sql server
satya - Friday, January 06, 2012 3:53:27 PM
transact sql delimited identifiers
transact sql delimited identifiers
satya - Friday, January 06, 2012 4:11:18 PM
For example you can do this
select something from table1.[public]
Notice the "[" around the key word public in case if you have named your field like that.
satya - Monday, January 09, 2012 11:35:18 AM
Sequence column issues
looks like when the access database is imported into sql server, the "id" columns are not identified as auto-sequence columns anymore.
this needs to be corrected. I am working on this now to identify what these tables and columns are and write a series of maintenance stored procedures to alter the tables to have these indexes.
satya - Tuesday, January 10, 2012 1:41:50 PM
See this link to see how to alter tables to have identity columns
See this link to see how to alter tables to have identity columns
satya - Thursday, January 12, 2012 9:11:13 AM
Currently ongoing task: document akc tables to show which are identify columns
I will post a link to the data model screen when I am done.
satya - Thursday, January 12, 2012 9:25:11 AM
Here is the link to akc data model
Here is the link to akc data model
Once you are on this page you can look for fields that are identity columns by searchign for "A," (case sensitive search).
In sql server you need to covert those tables one by one by altering the right columns to identity columns.
satya - Friday, January 20, 2012 8:33:27 AM
I have updated the identity columns as listed in the akc data model at the link above
I have updated the identity columns as listed in the akc data model at the link above
satya - Friday, January 20, 2012 8:34:03 AM
You can see the test scripts to run here
satya - Friday, January 20, 2012 8:35:19 AM
The function Now() doesnt exist in sql server
The function Now() doesnt exist in sql server
satya - Friday, January 20, 2012 8:35:52 AM
sql server function now()
sql server function now()
satya - Friday, January 20, 2012 8:44:46 AM
change reports.properties to adjust now() function to getdate()
change reports.properties to adjust now() function to getdate()
satya - Friday, January 20, 2012 11:52:57 AM
where else
append.properties
business-logic.properties
folder-views.properties
notes.properties
surl.properties
upload.properties
reports.properties
satya - Friday, January 20, 2012 4:47:49 PM
reports table: Provide a default value for column called public
reports table: Provide a default value for column called public
satya - Friday, January 20, 2012 4:48:04 PM
with that change most test cases have passed.
with that change most test cases have passed.
satya - Friday, January 20, 2012 4:48:18 PM
Majority is working
Majority is working
satya - Friday, January 20, 2012 4:51:51 PM
so what did i do
install sql server express
setup up userid/password
create a database
import access db
Change identity columns
Provide a default value for the reports table
download jdbc driver
download tomcat 6
create a tomcat service
hook up jdbc to akc
escape all "public" key words in properties files
with [] braces
replace "Now()" with "GetDate()"
That's it!!
satya - Friday, January 20, 2012 4:52:41 PM
Next step: understand backup and restore sql server database
Next step: understand backup and restore sql server database
Search for: Next step: understand backup and restore sql server database
satya - Saturday, February 04, 2012 2:25:37 PM
Here is how you can take backup and restore of sql server database
Here is how you can take backup and restore of sql server database
satya - Saturday, February 04, 2012 2:27:27 PM
Figure out how to run two tomcats
copy tomcat installation, the whole cuboodle
change server.conf to allocate different ports
you can use local host as an example
create a suitable mystartup.bat
and you can run both tomcats
satya - Saturday, February 04, 2012 2:47:40 PM
You will need help with service.bat and startup.bat: use this link
You will need help with service.bat and startup.bat: use this link
satya - Saturday, February 04, 2012 2:52:06 PM
AKC is actually running now on sql server in a test configuration
AKC is actually running now on sql server in a test configuration on the server in parallel with the production access version!!