Displaying posts categorized under

SMO

Create tables schema to another database using SMO

Create tables schema to another database using SMO. I have created a package which will create table script to your physical path and also executes same thing on another database to create table schema.

SSIS Package to Backup Jobs, Operators and Alerts Script using SMO

SSIS Package to Backup Jobs Script using SMO. This package willl use some SMO reference and generates SQL Server Jobs, Operators and Alerts script backup. I had written the code for SQL Server Jobs only and commented code for Operators backup and Alerts Backup. You just need to replcace Operators or Alerts instead of Jobs. [...]

SSIS Package to Backup Replication Script using SMO

SSIS Package to Backup Replication Script. Hi, This package willl use some SMO reference and generates SQL Server replication backup script same as you do it manually like, Right click on Publication –> Generate Scripts…. I have created SSIS package that automatically creates backup folder for current date and save your all replication publication script [...]