SQL Packager & SQL Server SP1: Self Deadlocking Transactions

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

SQL Packager & SQL Server SP1: Self Deadlocking Transactions

Postby NZJon » Wed Mar 21, 2007 6:37 am

Hi there,

With reference to a previous "conversation" (http://www.red-gate.com/messageboard/viewtopic.php?t=3567) and to a blog entry made by Andras (http://www.simple-talk.com/community/blogs/andras/archive/2006/06/09/859.aspx), I wonder whehter you would be able to answer a couple of questions.

We are experiencing the problems detailed by Andras, when deploying a SQL Packager "package" onto a client's SQL Server 2005 server. They have SQL Server 2005 SP1 installed, and we have been using SQL Packager 5.2.0.49.

Firstly, do you know whether the latest version of SQL Packager, 5.3, resolves the issues? Does it spilt out the XML Schema definitions into a separate transaction from its usage?

Secondly, do you know whether MS have changed how these works (aka. "fixed it") with SP2 or with a specific hotfix? I have not been able to find an MS article that describes the problem or mentions a fix.

Thanks for you time,

Jon
Jon Pawley,
Senior Software Engineer,
Wellnomics Limited,
www.wellnomics.com
NZJon
 
Posts: 3
Joined: Wed Mar 21, 2007 6:27 am

Postby Brian Donahue » Mon Mar 26, 2007 5:25 pm

Hi Jon,

I don't think any changes were made for Packager in this area. Maybe I can get Andras to look into whether SQL Server has resolved it on their end.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re:

Postby NZJon » Mon Mar 26, 2007 11:51 pm

Hi there Brian,

That would be good.

Without built-in support for this scenario, SQL Packager's value to us is
significantly decreased. In fact, you could argue that SQL Packager is broken.

At the moment, we have to implement a rather circuitous manual process of generating a C# project using SQL Packager, update the Visual Studio project to VS2005 format, modifying the project's resources so that the XML Schema's definition is in its own transaction, compile the project in Visual Studio, and finally deploy.

If there is anything we can do to provide you with more information, please do just ask. I look forward to getting this working.

Jon
Jon Pawley,
Senior Software Engineer,
Wellnomics Limited,
www.wellnomics.com
NZJon
 
Posts: 3
Joined: Wed Mar 21, 2007 6:27 am


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests