blocks|key|1544052|text|移动数据库的最简单方法是使用SQL+server+Management+Studio将数据库导出到另一台服务器，或者，如果此方法不起作用，请按照其他人的建议创建备份并将其恢复到其他位置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1544053|如果您正在寻找一种将表结构转储到SQL并为数据创建插入脚本的方法，一个很好的免费选择是使用http://www.asql.biz/en/Download2005.aspx中的amScript和amInsert。|offset|length|1544054|如果你想要一个好的付费版本，我可以看看Red-Gate+SQL+Compare和Red-Gate+SQL-Data+Compare。不过，这些工具可能有些夸大其词，如果你不打算经常使用它们，可能会有点贵。我认为这主要是由DBA完成的。您可以在http://www.red-gate.com/上查看红门工具。|1544055|entityMap|0|LINK|mutability|MUTABLE|url|http://www.asql.biz/en/Download2005.aspx|1|http://www.red-gate.com/^0|0|19|14|0|0|3D|O|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

The easiest way to move a Database would be to use SQL Server Management Studio to Export the database to another server, or if that doesn't work, make a backup like other's had suggested and restore it elsewhere.

If you are looking for a way to dump the table structure to SQL as well as create insert scripts for the data a good free option would be to use amScript and amInsert from <a href="http://www.asql.biz/en/Download2005.aspx" rel="noreferrer">http://www.asql.biz/en/Download2005.aspx</a>.

If you want a good pay version I would check out Red-Gate SQL Compare and Red-Gate SQL-Data Compare. These tools are probably overkill though and probably a bit pricey if you don't intend to use them a lot. I would think it would mostly be relegated to DBAs. You can look at the Red-Gate tools at <a href="http://www.red-gate.com/" rel="noreferrer">http://www.red-gate.com/</a>.

blocks|key|1544153|text|由于找不到合适的工具，我决定创建自己的工具:+sqlserverdump命令行实用程序。在github上查看它。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1544154|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/daniel-jann/sqlserverdump/^0|19|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Not finding the right tool, I decided to create my own: a sqlserverdump command line utility. Check it out on <a href="https://github.com/daniel-jann/sqlserverdump/" rel="nofollow noreferrer">github</a>.

blocks|key|1759040|text|更简单的是使用SMO+API。它可以让你完全像mysqldump那样做，甚至更好。下面是一个代码示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1759041|http://samyem.blogspot.com/2010/01/automate-sql-dumps-for-sqlserver.html|offset|length|1759042|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|20|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

Even easier is to use the SMO API. It lets you do exactly like mysqldump, and even better. Here is a code example:

<a href="http://samyem.blogspot.com/2010/01/automate-sql-dumps-for-sqlserver.html" rel="nofollow noreferrer">http://samyem.blogspot.com/2010/01/automate-sql-dumps-for-sqlserver.html</a>

blocks|key|1758716|text|Mysqldump是一系列SQL语句。使用DTS可以做到这一点，但为什么不创建一个备份并将其恢复到新机器上呢？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1758717|如果您希望通过SQL：http://msdn.microsoft.com/en-us/library/aa225964(SQL.80).aspx来完成此操作|offset|length|1758718|或者，只需右键单击数据库，然后单击Tasks+->+Backup+(http://msdn.microsoft.com/en-us/library/ms187510.aspx)|1758719|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/aa225964(SQL.80).aspx|1|http://msdn.microsoft.com/en-us/library/ms187510.aspx^0|0|B|1P|0|0|Y|1H|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

Well, Mysqldump is a series of SQL statements. You can do this with DTS, but why not just create a backup and restore it on your new machine?

If you want to do it via SQL:
<a href="http://msdn.microsoft.com/en-us/library/aa225964(SQL.80).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/aa225964(SQL.80).aspx</a>

Or just right click the DB and hit Tasks -> Backup (<a href="http://msdn.microsoft.com/en-us/library/ms187510.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms187510.aspx</a>)

blocks|key|1758787|text|最简单的方法是备份和恢复或分离和连接|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1758788|或者编写所有表和BCP的脚本，然后在新服务器上的数据中编写BCP|1758789|或者使用DTS/SSIS来完成此操作|1758790|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

easiest would be a backup and restore or detach and attach

or script out all the tables and BCP out the data then BCP in the data on the new server

or use DTS/SSIS to do this

blocks|key|1758844|text|SQL企业管理器或SQL+Server+Management+studio具有基于向导的方法，后者将生成脚本，以便您可以看到它是如何完成的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1758845|您还可以使用备份和还原命令。更多细节在这里：http://msdn.microsoft.com/en-us/library/ms189826.aspx|offset|length|1758846|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms189826.aspx^0|0|M|1H|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

SQL Enterprise manager or SQL Server Management studio have wizard based approaches, and the latter will generate the scripts so you can see how its done. 

You could also use the BACKUP and RESTORE commands. More detail here: <a href="http://msdn.microsoft.com/en-us/library/ms189826.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms189826.aspx</a>

blocks|key|1543979|text|如果可以将DTS或Integration+Services连接到这两台服务器，则可以使用向导将对象从一台服务器“复制”到另一台服务器。“复制数据库”要求两台服务器可以相互进行身份验证，这通常意味着在相同的域上，并且服务在域登录下运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1543980|否则，您可以为架构生成脚本，并且可以使用Integration+Services/DTS包将数据导出到一个文件，然后将其导入另一个文件。|1543981|我们现在通常使用SQL+Compare和SQL+Data+Compare。红门公司的SQL+Packager可能也是一个选择。|offset|length|1543982|entityMap|0|LINK|mutability|MUTABLE|url|http://www.red-gate.com/products/SQL_Compare/index.htm|1|http://www.red-gate.com/products/SQL_Data_Compare/index.htm|2|http://www.red-gate.com/products/SQL_Packager/index.htm^0|0|0|8|B|0|K|G|1|16|C|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$F|W|G|X|1|Y]|$F|Z|G|10|1|11]|$F|12|G|13|1|14]]|A|$]]|$1|H|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]|R|$5|K|L|M|A|$N|S]]]]

If you can get DTS or Integration Services to connect to both servers, you can use the wizards to 'copy objects' from one server to another. 'Copy Database' requires that the two servers can authenticate with each other, which typically means being on the same domain and that the service runs under a domain logon.

Otherwise, you can generate a script for the schema, and you can use an Integration Services/DTS package to export data to a file, then import it on the other.

We now generally use <a href="http://www.red-gate.com/products/SQL_Compare/index.htm" rel="nofollow noreferrer">SQL Compare</a> and <a href="http://www.red-gate.com/products/SQL_Data_Compare/index.htm" rel="nofollow noreferrer">SQL Data Compare</a>. Red Gate's <a href="http://www.red-gate.com/products/SQL_Packager/index.htm" rel="nofollow noreferrer">SQL Packager</a> might also be an option.

blocks|key|1544262|text|如果您需要等价的SQL语句，如CREATE+TABLE...插入到...中，然后我建议您尝试HeidiSQL。这是一个很棒的免费工具，可以访问Microsoft+SQL+Server，MySQL和PostgreSQL。它使您能够浏览和编辑数据，创建和编辑表、视图、过程、触发器和计划的事件。此外，还可以将结构和数据导出到SQL文件。http://www.heidisql.com|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1544263|转到Tools+/+Export+database+as+SQL并选择模式。选中该框可创建表并“插入”数据。就这样。|1544264|与"Microsoft+SQL+Server+Management+Studio“或phpMyAdmin相比，我更喜欢HeidiSQL+...等。|1544265|entityMap|0|LINK|mutability|MUTABLE|url|http://www.heidisql.com/^0|4M|N|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

If you need equivalent SQL statements like CREATE TABLE... &amp; INSERT INTO..., then I recommend you try HeidiSQL. It's a fantastic and free utility that can access Microsoft SQL Server, MySQL and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data to SQL file.
<a href="http://www.heidisql.com" rel="nofollow noreferrer">http://www.heidisql.com</a>

Go to Tools / Export database as SQL and select the schema.
Check the box to create the tables and “Insert” data. That’s it.

I prefer HeidiSQL to "Microsoft SQL Server Management Studio" or phpMyAdmin... etc.

Is there an equivalent schema &amp; data export/dumping tool for SQL Server as there is for MySQL with mysqldump. Trying to relocate a legacy ASP site and I am way out of happy place with working on a windows server.

Note: The DTS export utility own seems to export data, without table defs.
Using the Enterprise Manager and exporting the db gets closer with exporting the schema &amp; data... but still misses stored procedures.

Basically looking for a one does it all solution that grabs everything I need at once.

mysqldump equivalent for SQL Server

身份验证

SQL Server

PostgreSQL

数据库

服务器

MySQL

对于SQL Server，有没有一个与mysqldump的MySQL相当的模式和数据导出/转储工具？试图重新定位一个遗留的ASP站点，但我在windows服务器上工作却走出了快乐的境地。注意: DTS导出工具own似乎可以导出数据，而不需要表定义。使用Enterprise Manager和导出数据库与导出模式和数据更接近...但是仍然缺少存储过程。基本上是在寻找一种一劳永逸的解决方案，一次就能抓住

问SQL Server的mysqldump等效项
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server的mysqldump等效项EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server的mysqldump等效项
EN