Red Gate forums :: View topic - Frustrated that user creation errors always abort the script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Frustrated that user creation errors always abort the script

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbouchard@tricomputer.com



Joined: 11 Mar 2010
Posts: 6

PostPosted: Thu Mar 11, 2010 5:34 pm    Post subject: Frustrated that user creation errors always abort the script Reply with quote

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...
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Mar 15, 2010 2:01 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group