如何获取SQL Server数据的脚本? [英] How to get script of SQL Server data?
问题描述
我正在寻找一种类似于SQL Server的MySQL转储的方法。我需要能够选择表并导出模式和数据(或者我可以通过SQL Server Management Studio导出模式,并以某种方式导出数据)。
I'm looking for a way to do something analogous to the MySQL dump from SQL Server. I need to be able to pick the tables and export the schema and the data (or I can export the schema via SQL Server Management Studio and export the data separately somehow).
我需要这些数据才能转身回到SQL Server,因此需要维护GUID /唯一标识符和其他列类型。
I need this data to be able to turn around and go back into SQL Server so it needs to maintain GUIDs/uniqueidentifiers and other column types.
有谁知道一个
推荐答案
为了完整,我也发现这样做: Microsoft SqlServer数据库发布向导
Just for completeness, I also found this way to do it: Microsoft SqlServer Database Publishing Wizard
这篇关于如何获取SQL Server数据的脚本?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!