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.
看起来SQL Server Management Studio生成的SQL脚本速度非常慢。我认为旧的企业管理器可以围绕较新的脚本生成工具运行。我在这里和那里看到了一些帖子和其他人抱怨速度,但我没有看到提供替代品的方式。
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.
是否有一个低成本/免费的工具来编写整个SQL Server 2005数据库的脚本,它将比SSMS表现更好?这样做会很难。
4 个解决方案
#1
3
See the Database Publishing Wizard that is part of the SQL Server Hosting Toolkit. It generates a single SQL file for both schema and data.
请参阅作为SQL Server Hosting Toolkit一部分的数据库发布向导。它为架构和数据生成单个SQL文件。
#2
3
We are using the tools by RedGate which I personally find very useful in any aspect of work with databases. For scripting I would recommend the SQL Compare (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.
我们正在使用RedGate的工具,我个人认为这些工具在数据库工作的任何方面都非常有用。对于脚本,我建议使用SQL Compare(你需要一个专业版的脚本)。 SQL Compare是将部署数据库中的架构更改部署到实时服务器和实时节省器的必备条件。
Those tools are not free but I think they could save you money in a long run
这些工具不是免费的,但我认为从长远来看它们可以省钱
#3
1
I don't know what is "terribly slow" for you, but I have a decent performance with SQL 2005 Management Studio. In either case, RedGate products are very cool. Unfortunately they are not free.
我不知道你的“非常慢”是什么,但我在SQL 2005 Management Studio上表现不错。在任何一种情况下,RedGate产品都非常酷。不幸的是他们不是免费的。
#4
0
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. But 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.
你现在在讨论什么类型的scrpt?,与EM相比,SSMS中的对象生成创建脚本的速度要快得多。但是如果你正在运行一个select或者在网格中给你很多行的东西,那就太疯狂了......就像脚本生成表中所有行的insert语句一样,如果你有大量的数据,那几乎是不可行的。
#1
3
See the Database Publishing Wizard that is part of the SQL Server Hosting Toolkit. It generates a single SQL file for both schema and data.
请参阅作为SQL Server Hosting Toolkit一部分的数据库发布向导。它为架构和数据生成单个SQL文件。
#2
3
We are using the tools by RedGate which I personally find very useful in any aspect of work with databases. For scripting I would recommend the SQL Compare (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.
我们正在使用RedGate的工具,我个人认为这些工具在数据库工作的任何方面都非常有用。对于脚本,我建议使用SQL Compare(你需要一个专业版的脚本)。 SQL Compare是将部署数据库中的架构更改部署到实时服务器和实时节省器的必备条件。
Those tools are not free but I think they could save you money in a long run
这些工具不是免费的,但我认为从长远来看它们可以省钱
#3
1
I don't know what is "terribly slow" for you, but I have a decent performance with SQL 2005 Management Studio. In either case, RedGate products are very cool. Unfortunately they are not free.
我不知道你的“非常慢”是什么,但我在SQL 2005 Management Studio上表现不错。在任何一种情况下,RedGate产品都非常酷。不幸的是他们不是免费的。
#4
0
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. But 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.
你现在在讨论什么类型的scrpt?,与EM相比,SSMS中的对象生成创建脚本的速度要快得多。但是如果你正在运行一个select或者在网格中给你很多行的东西,那就太疯狂了......就像脚本生成表中所有行的insert语句一样,如果你有大量的数据,那几乎是不可行的。