<p>It seems like the generation of SQL scripts from the SQL Server Management Studio is terribly slow. I think that the old Enterprise Manager could run laps around the newer script generation tool. I've seen a few posts here and there with other folks complaining about the speed, but I haven't seen much offered in the way of alternatives.</p>

<p>Is there a low-cost/free tool for scripting an entire SQL Server 2005 database that will perform better that SSMS? It would be hard to do worse. </p>

[{'answer_id': 31301, 'author': 'Martin Marconcini', 'author_id': 2684, 'author_profile': 'https://Stackoverflow.com/users/2684', 'pm_score': 0, 'selected': False, 'text': '<p>I don\'t know what is "terribly slow" for you, but I have a decent performance with SQL 2005 Management Studio. In either case, <a href="http://www.red-gate.com/" rel="nofollow noreferrer">RedGate</a> products are very cool. Unfortunately they are not free.</p>\n'}, {'answer_id': 31315, 'author': 'neslekkiM', 'author_id': 3308, 'author_profile': 'https://Stackoverflow.com/users/3308', 'pm_score': 0, 'selected': False, 'text': '<p>What kind of scrpt generation are you talking about now?, generating create scripts from the objects in the database is way faster in SSMS compared to EM.\nBut if you are running an select or something that gives you lots of rows in the grid, it is crazy slow.. like scripts generating inserts statements of all rows in an table, if you got lots of data, it is almost not doable.</p>\n'}, {'answer_id': 31361, 'author': 'kristof', 'author_id': 3241, 'author_profile': 'https://Stackoverflow.com/users/3241', 'pm_score': 2, 'selected': False, 'text': '<p>We are using the tools by <a href="http://www.red-gate.com/" rel="nofollow noreferrer">RedGate</a> which I personally find very useful in any aspect of work with databases. For scripting I would recommend the <a href="http://www.red-gate.com/products/SQL_Compare/index.htm" rel="nofollow noreferrer">SQL Compare</a> (you need a pro version for scripting). The SQL Compare is a must have for deploying schema changes from the deployment DB to the live Server and a real timesaver.</p>\n\n<p>Those tools are not free but I think they could save you money in a long run</p>\n'}, {'answer_id': 31391, 'author': 'Duncan Smart', 'author_id': 1278, 'author_profile': 'https://Stackoverflow.com/users/1278', 'pm_score': 3, 'selected': True, 'text': '<p>See the <a href="http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard" rel="nofollow noreferrer">Database Publishing Wizard</a> that is part of the <strong>SQL Server Hosting Toolkit</strong>. It generates a single SQL file for both schema and data.</p>\n'}]
['https://Stackoverflow.com/questions/31296', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/162/']