Frustrated that user creation errors always abort the script

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

Frustrated that user creation errors always abort the script

Postby dbouchard@tricomputer.com » Thu Mar 11, 2010 5:34 pm

Is it just me or am I doing something wrong? I frequently create initial databases on my dev system for my clients and then try to use SQL Packager to package my db so that I can then install it on my client's system. I always have sys admin access on both sql servers. I use all the default options and create an executable to run on my client's network. Most times, the executable fails trying to create a user, throws up a pop-up window alerting me to the failure and then aborts the entire process. Any reason why the SQL Packager doesn't try to continue from the error if the user so chooses??? More often than not, I end up going back to my dev system, rerun SQL Packager, either deselect the user creation from the list of objects to create and rerun fine or I simply take the sql scripts created, delete the offending login/user creation line, and rerun fine. Why couldn't SQL Packager do the same thing?

Thanks for any insights about this extremely frustrating situation...
dbouchard@tricomputer.com
 
Posts: 6
Joined: Thu Mar 11, 2010 5:28 pm

Postby Chris Auckland » Mon Mar 15, 2010 2:01 pm

Thanks for your post.

You could try using the option 'Do not use transactions in synchronization scripts'.

This option will set the script to not use transactions, so any problems encountered will not cause the script to roll back.

This might result in the database being left in an inconsistent state.

I hope it helps.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests