migrating one database to another RRS feed

  • Question

    I tried ssis just because my database is not normalized it does,t work. so I wrote a program. but have problems. The soft where creates an intermediate database to migrate an Access Database to with allow all null values. Then I have to migrate from the intermediate database to my real database because it does not allow null values it crashes. So I wrote so it will ignore null values. So cool that works now I am having problems because my real database have example( contact table) ( 25 column names) intermediate database (contact table) (10 column names) because the table are different in the number columns names I getting errors where the columns don't exist. I would like to have my code do something to the effect of

     if objectcolumen exist() update else goto next, or skip,

    Please give an example.

    • Edited by SHELBYOH Monday, September 29, 2008 2:50 PM
    • Moved by jack 321 Thursday, October 2, 2008 2:42 AM off topic (Moved from Visual C# General to Off-Topic Posts (Do Not Post Here))
    Monday, September 29, 2008 2:49 PM