January 26, 2009 at 8:42 am
Give idea about transfer complete db2 database to sql server 2005 with the help of SSIS
January 26, 2009 at 9:22 am
I'd say that your best bet is to start with working out what tables you need, how portable your code is, and so on. SSIS can help with loading data, even with creating objects (tables, etc.), but it's going to be better to do some homework first.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 26, 2009 at 9:39 am
One important question when considering options is how much data needs to be transfrerred?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 26, 2009 at 1:04 pm
I have 20 tables not huge amount of data need need to have same structure at sql server 2005
.How to transfer whole structure from db2 to sql server 2005 with the help of SSIS
January 26, 2009 at 3:01 pm
You might be able to do that with the Import Wizard.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply