开发者

SQL Server Management Studio 2008 R2 Export Structure + Data

I want to export the structure and data in my database into a .sql file to then execute as a query on 开发者_Go百科another machine.

Any ideas on how this can be achieved? I have tried using the database import/export wizards to no avail...


Right click on database, to go tasks, generate scripts. Make sure you choose the option "Schema and Data" for what "Types of Data to Script" when clicking on the "Advanced" button.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜