Creating a Package From Script Fails

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

Creating a Package From Script Fails

Postby chrisrm » Tue Nov 03, 2009 11:17 am

I have encountered a problem with the Packager when generating from a saved script. On the most basic test of making a change to 1 stored procedure and then generating a change script for this. The upgrade package fails. If I save the generated upgrade package as C# project it shows that the packager is breaking up the script into too many batches. Specifically, the changed procedure in my simple test is being broken up and run as many batches and therefore fails.

I would expect that this should work and cannot see a reason for the procedure being broken into batches in this way.

Has anyone else encountered this or know of a fix?
chrisrm
 
Posts: 5
Joined: Tue Nov 03, 2009 11:06 am

Fix

Postby chrisrm » Wed Nov 04, 2009 1:02 pm

Applying the latest cumulative package has fixed this.

http://www.red-gate.com/MessageBoard/vi ... php?t=9883
chrisrm
 
Posts: 5
Joined: Tue Nov 03, 2009 11:06 am


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests