> -----Original Message----- > From: Bruce Sorge [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 28, 2007 1:02 PM > To: CF-Talk > Subject: Any good resources for importing MS SQL 2000 DB to DB2 > > I goggled this but cannot find anything useful. Basically, I have a > SQL2K DB > that I have been developing on, but the production is DB2. So I > modified the > scripts to create the tables and what not, but the problem I have is > getting > the actual data from the SQL Server to the DB server. So does anyone > have a > link to a good resource to show a DB2 beginner how to do this?
First of all - my condolences (I've been forced to use DB2 for a coupla years now...) SQL Server DTS (Data Transform Services) should do this fine - just make sure that you have an connection to the DB2 server on the SQL Machine. Install (the awful) DB2 client tools and set up a connection to the DB - make sure to include an ODBC connection. You should then be able to choose that DB as a target in the DTS tool. For complex transforms the DTS tool allows you to visually create a data flow path with extracts/transforms/loads at specific points. You can then save the package to run again or to schedule. SQL Server DTS: reason 11,345 why I miss SQL Server. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276489 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4