Thanks Del, I'd like to have ERwin to do the modeling & synching (sp?), but I'm afraid that won't happen.
>>>I'm not wanting to replicate an entire database. Or is there a built in SP that I can use that will give me a script to create the table?
>
>In SEM, you can use Tools | Generate SQL Script to create a script for the database. You can then execute this script in your target database. At that point, you can use DTS to copy data (DTS may do it all anyway, I can't recall).
>
>FYI, there are tools that will do structure compares and can also create scripts to synchronize the data structures. See
http://www.f1tech.com/xcase or
http://www.red-gate.com for examples.
Steve Gibson