正常的方法是备份/恢复。如果您要移动架构，则需要遍历依赖关系结构，因为您需要先处理外键并首先创建适当的表和视图。



我们使用Red-Gate工具套件进行此类操作，但它们不是免费的！

The normal way of doing this is backup/restore. If you are going to move the schema only you are going to need to walk the dependency structure as you will need to cater for foreign keys and create the appropriate tables and views first.

We use Red-Gate suite of tools for this type of operation but they are not free!