-
Schema Transfer
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|