I have a schema of tables, stored procs, etc that I needs to push into many individual databases 1x1

thoov

I have a schema of tables, stored procs, etc, That I need to push into many existing individual databases. Do you have a tool that will help do that? This is a repeating task that I perform multiple times a day, but for different databases each time.

Jon_Shaulis

thoov, I want to say they have Data Compare, SQL Compare, and SQL Clone that can probably get you close or are at least worth researching. In the past when I have a large sum of things I need to push from A to C, I typically use Dynamic SQL, BCP, SSIS, or BIML paired with SSIS to achieve that goal.