sql server migration

sql server migration

ms sqlserver download

Search for: ms sqlserver download

Download sql server express from here


admin/admin1234

sql server books online

cannot connect to SQL Server (SQLEXPRESS)

Search for: cannot connect to SQL Server (SQLEXPRESS)


(local)\sqlexpress
use windows nt authentication

Import access database into sql server express

Search for: Import access database into sql server express


Create a database of your own
right click on database
tasks
import
pick the ms-access
pick the file
On you go...

where is jdbc driver for sql server express?

Search for: where is jdbc driver for sql server express?

This is an interesting post on sql and azure and cloud for java

Here is from the source msdn on jdbc

you can also download the driver from that link

here is how you build the connection string


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

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?

How can I pass userid and password that is not a windows userid/password?

How can I login using a non windows password into sql server?

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
satya1234

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.

what is the default sqlserver sa password?

Search for: what is the default sqlserver sa password?

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" 


sql manager studio
security
login
your-user
properties
default database
pick your database

Various microsoft data sources are listed here


com.microsoft.sqlserver.jdbc.SQLServerDataSource
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
com.microsoft.sqlserver.jdbc.SQLServerXADataSource

com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

Search for: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

about jdbc connection pool data sources

Search for: about jdbc connection pool data sources

satya komatineni ConnectionPoolConnectionManager5

Search for: satya komatineni ConnectionPoolConnectionManager5

How can I control what ports sql server listens on: an msdn article

sqljdbc.jar or sqljdbc4.jar

Search for: sqljdbc.jar or sqljdbc4.jar

Here is how you choose one or the other

this jar supports JDBC 4.0 standards.

which supports jdbc 3.0 standard.

I seem to have jdk 16 (which is 6)


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

Here is how you control the tomcat memory and which jdk to use


<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>


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"

where can I find about the jdbc sql server driver name for a connection


Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String connectionUrl = 
"jdbc:sqlserver://localhost;database=AdventureWorks;"
Connection con = DriverManager.getConnection(connectionUrl);


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

where can I find tomcat service log files such as stdout and stderr

/tomcat-install-root/logs

tomcat 7 class not found org.apache.xerces.readers.StringReader

Search for: tomcat 7 class not found org.apache.xerces.readers.StringReader

taglib definition not consistent with specification version

Search for: taglib definition not consistent with specification version

Not sure what that means for porting or tag libraries that are used. Or may be I go back to tomcat6??

On the server I am using tomcat6. May be I will just stick with that one!

Here is one good link when I do decide to migrate to tomcat 7

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.

sql server express localhost jdbc connection refused

Search for: sql server express localhost jdbc connection refused

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. 


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

It should be 1434

where is the sql server express log file located?

Search for: where is the sql server express log file located?

After I did this I am able to create a jdbc connection. I am almost getting there.

problems with keyword public in sql server

Search for: problems with keyword public in sql server

transact sql delimited identifiers

Search for: transact sql delimited identifiers


select something from table1.[public]

Notice the "[" around the key word public in case if you have named your field like that.

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.

See this link to see how to alter tables to have identity columns

I will post a link to the data model screen when I am done.

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.

I have updated the identity columns as listed in the akc data model at the link above

You can see the test scripts to run here

The function Now() doesnt exist in sql server

sql server function now()

Search for: sql server function now()

change reports.properties to adjust now() function to getdate()


append.properties
business-logic.properties
folder-views.properties
notes.properties
surl.properties
upload.properties
reports.properties

reports table: Provide a default value for column called public

with that change most test cases have passed.

Majority is working


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!!

Next step: understand backup and restore sql server database

Search for: Next step: understand backup and restore sql server database

Here is how you can take backup and restore of sql server database


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

You will need help with service.bat and startup.bat: use this link

AKC is actually running now on sql server in a test configuration on the server in parallel with the production access version!!