Options

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

thoovthoov Posts: 1 New member
in General Forum
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.
Tagged:
· Share on Twitter

Answers

  • Options
    Jon_ShaulisJon_Shaulis Posts: 3 Bronze 1
    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.
    · Share on Twitter
Sign In or Register to comment.