Actually I'm not sure what's in the Import/Export Wizard. I've not used it it in a very log time. I assumed that you were writing a script to move the changes and new data over to the production database.

-Mike


>Are you hinting that the Import/Export Wizard permits configuration down to the field level? If so, I must've missed it...
>
>
>
>>>Now that I think about it, though, it's probably not all that important, since when I move the tables back into production (I've modified the structures) the identity fields probably aren't copied over with it. They should correct themselves according to the table they're in, yes?
>>
>>This will depends on how you "move the table back into production." If you copy the data over and don't copy the identity value, sql server will use the next identity.
>>
>>-Mike