I'm trying to convert Informix to MS SQL Server. The database size is 220 GB. There are about 19K tables and 11K views and I'm trying to only bring in the tables. Using import wizard is out of the question since the GUI is so slow and I don't want to click 11K times to deselect the views and I'm new to DTS scripting. Has anyone done this? Also second issue I have is that the source DB has the objects in lower case names and I need the object names to be in upper case when they come in.

I just want to be able to pull in the tables at this point to establish baseline timeline. I can still tackle the upper case transformation after that. I was thinking about creating a dymnic SQL for the rename to upper but I would also appreciate any tips here too.

Thanks,

Import your tables first then your views. In the data transformation change to default the data to caps. UPPER(RTRIM(columnName))

Jaime E. Maccou