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
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...
- Posts: 6
- Joined: Thu Mar 11, 2010 5:28 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.
- 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