Creating a Package From Script Fails

Forum for users of SQL Packager database archive utility

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 Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests