Hello to all,

I created new tables, indexes and relationships within a development database. Except for these new tables, my client's production database is exactly the same as the development copy. I now want to copy my work from the development to the production database.

So far, I attempted to open two copies of SDT explorer and drag the tables I wanted from one database to the other. This effectively copied the tables to the proper directory, along with their corresponding indexes. However, relations with other tables and the Referential Integrity definitions were not carried over.

How can I also have relationships created automatically? I would much prefer everything be automated.

Thanks,

Bruno Di Lalla
Consultant

HAPPY NEW YEAR!