For an automated setup build that generates the setup for an application which uses Microsoft SQL Server, I am currently evaluating whether the following is possible:
I want to programmatically (CMD script or C# code) execute the function "Generate Scripts" on a database that is accessible from Microsoft SQL Server Management Studio 2008.
I.e. call some code and have all the objects (tables, SPs, constraints, etc.) of a specified database as an SQL script.
Currently, I only need the structure, not the data.
Question: Is it possible to achieve this goal?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…