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

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

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

Postby shaffer911 » Thu Apr 12, 2012 1: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?

Thanks,

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

Postby eddie davis » Fri Apr 13, 2012 2: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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests