How do I generate SQL database script using C# or SQL?

Question

How do I generate SQL database script using C# code or SQL code?

We can use the Generate Scripts option from ssms but how do I generate SQL database script using code?

Shahar Gvirtz · Accepted Answer · 2016-05-02 08:53:38Z

9

You should use SQL Server SMO (Server Management Object) that includes exactly the features you're looking for. You can script single database, or specific objects. Actually, that's how SSMS does it.

Blog post: http://weblogs.asp.net/shahar/generating-sql-backup-script-for-tables-amp-data-from-any-net-application-using-smo

MSDN sample for scripting database: https://msdn.microsoft.com/en-us/library/ms205825.aspx

https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.scripter.aspx

answered May 2, 2016 at 8:53

Shahar Gvirtz

2,4481 gold badge14 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I generate SQL database script using C# or SQL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related