I just landed a gig where part of the requirements will be to convert a
Websphere application to a Microsoft IIS 5.1 platform entailing a need to
migrate the underlying DB2 database to SQL Server 2000. My initial
thought/plan is to take the websphere JAVA stuff (seems the application is
all JSP) and copy it over onto a IIS machine, install Tomcat, and see
what I'll need to do to the code to make the app deploy and act nice. The DB2 database will need to be recreated manually or somehow
exported generically and imported in a fashion SQL Server can handle.
I did find all the DTD scripts, so the manual creation is not that
daunting (though there are scores of tables). Does anyone have any
pointers, tips, war stories, etc on how to accomplish this and what traps to avoid?
Da Lizard