Hi everybody,

I need your help.

My goal is to copy a set of database tables along with database objects attached to them, such as triggers, PKs and FKs, from a development database into a test database.

My first try: export utility, it worked only on part of table schema and the data. It missed all PKs, FKs, identity properties, and triggers.

My second try: Reverse Engineering in ERwin. It worked only if you reverse engineering an entire database. I do not know how to make it work for a set of tables.

Only way I currently use: generate script of tables, reorder the statements, and run the script against the destination database.

I am wondering if there are some utilities offered by SQL Server 7 or third parties I can use to reach my goal.

I will appreciate if any of you give me some suggestions.

Thanks.

Helen