I uncheck that I don't want Functions packaged up...

Forum for users of SQL Packager database archive utility

I uncheck that I don't want Functions packaged up...

Postby shaffer911 » Thu Apr 12, 2012 12:34 pm

Good Morning,

Using Packager to package a SQL Server 2008R2 database.

I uncheck all the Functions and Stored Procedures because I don't need / want those packaged up.

Package is generated successfully, however it INCLUDES functions, despite me unchecking those.

Am I doing something incorrectly?


Posts: 1
Joined: Thu Apr 12, 2012 12:31 pm

Postby eddie davis » Fri Apr 13, 2012 1:23 pm

Hi Shaffer911

Thank you for your post into the forum.

I suspect that you did not disable the "Include dependencies" option before creating your SQL Packager project. Although you did not include your functions or stored procedures, if you have included objects that have dependencies to the deselected objects they will still be included as the "Include dependencies" option is checked or enabled by default.

To turn off or disable the "Include dependencies" option follow the steps below:

1. Start up SQL Packager, when the packager window opens - close or cancel the diaglog box on the type of package you wish to create.

2. Now select the Tools menu ->Options ->Schema Options Tab ->Behavior section ->Uncheck or disable the "Include dependencies" option. Click OK to save the changes.

3. Now create your project using the New Project... button. When the package is created it should not include the dependent objects.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
Posts: 1138
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests