scripting - Generate script for all objects for SQL Server Database -

-

I used the SMO object to generate the SQL script for database objecrs for SQL Server. When a local network has a database, it works well. But if the database is in a remote server then it takes a lot of time to generate the best and fastest way to generate scripts for SQL Server objects when the database is in a remote server.

I will use SQL Server Management Studio

Right click from the database item Select more actions, generate scripts There are several options for you.

(You can also get this script data in the table.)


Comments

Post a Comment