I just landed a gig where part of the requirements will be to convert a Websphere application to a Microsoft platform entailing a need to migrate the underlying DB2 database to SQL Server 2000. My initial thought is to take the websphere JAVA stuff (seems the application is all JSP) and copy it over onto a IIS machine, install Tomcat to make JSP useful, and see what I'll need to do to the code to make the app deploy and act nice. But, 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 and tips on how to accomplish this?

Da Lizard