SQL Packager 5.4 - Including dependent stored procedures

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

SQL Packager 5.4 - Including dependent stored procedures

Postby rbergmeyer » Fri Feb 13, 2009 10:22 pm

Hello,
I am attempting to create a package for one table in a database. I have the include dependencies option checking. When the script is generated, I am not seeing the creation of the stored procedures for the table. Dependency Tracker is showing me that there are 3 depend stored procedures. Should they automatically be scripted or did I have to know the stored procedures associated with the table and manually select them?

Thanks,
Rob
rbergmeyer
 
Posts: 2
Joined: Mon Jun 02, 2008 9:01 pm
Location: Canton, Ohio USA

Postby Brian Donahue » Mon Feb 16, 2009 7:06 pm

Hi Rob,

With Packager, the dependent objects are scripted, not objects that depend on a particular object. If you were using Dependency Tracker, you should see Packager automatically script objects that are used by the object you wanted to package rather then the objects that use the object.

I hope that this helps.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby rbergmeyer » Thu Feb 19, 2009 5:14 pm

Hello,
I understand now, thank you for clearing that up for me.
Regards,
Rob
rbergmeyer
 
Posts: 2
Joined: Mon Jun 02, 2008 9:01 pm
Location: Canton, Ohio USA


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests