I have 5 SQL database ( Web Edition ) in Azure that should be exactly the same as the structure (
triggers … ) but the data is different.
Can you update the bank structure in a more agile way, as if they were a mirror of a master bank?
I have discovered something that solves my problems.
SQL Server Management Studio 2008 has a feature called Registered Databases.
After you register the databases with their credentials, you can run a script on all the banks at the same time.
To do this:
Now to run scripts all at once, just go to View > Registered Servers. Or press Ctrl + Alt + G.
Expand the “Database Engine,” right-click “Local Server Groups” > “New Inquiry”.
Notethatifthereismorethanoneserverinthe”Local Server Groups” the status bar of the script area will turn red indicating that the command will run on behalf of multiple logons.