August 18, 2008 at 10:27 pm
Do you recommend any database scripting tools? The scripting option built into Management Studio is too slow for our needs and we are in search of an alternative. DBArtisan is an expensive option, but we are hoping to find something more affordable.
Thanks, Dave
August 19, 2008 at 12:05 am
Hello,
To script an entire DB we often use Red Gate's SQL Compare.
We create an empty target DB and run a full compare between that and the DB that we want to copy. The Synchronisation Wizard can then be used to build a script.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
August 19, 2008 at 4:54 am
I do the same thing with xSQL Object - compare the database to an empty one to generate an entire DB script.
What are you doing that requires high-performance database object scripting? Barring a huge database taking days, what is the difference how long it takes?
August 19, 2008 at 5:22 am
Redgate gets my vote
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 7:08 am
We have Red Gate, but have never used it to script databases, only compare. I'll give that a try.
In regards to the question about performance it's just not acceptable to wait 2 hours (or more) for a script to be created when the same script in SQL 2000 took about 5 minutes. On occassion we will generate a script and then find out we need to change a scripting option and re-run the script generation for another hour or two. I have no problem multitasking, but these kind of delays are frustrating.
Thanks, Dave
August 19, 2008 at 9:45 am
Red Gate will work when we want to script an entire database, but if we want to script specific items such as indexes and constraints only, then Red Gate won't work. Red Gate said they are considering adding this feature to a future release.
Still looking for options.
Thanks, Dave
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply