|
|
create a synonym in a "To Schema" for each Table in the "From Schema"
File Details
| Downloads: |
375 |
File Size: |
3.4kB |
| Posted By: |
admin |
Views: |
629 |
| Date Added: |
Mon, Mar 31 2008 |
|
This script will create a synonym in a "To Schema" for each Table in the "From Schema" (if it doesnt already exist). You should edit the FromSchemaName and ToSchemaName before running the script. To run it:
1) bring up the Script Explorer 2) right click on "User Defined" and select "New Script" 3) copy/paste the attachment into the edit control 4) hit the run button (the first icon in the toolbar above the edit control) Note: you can undo/redo the effects of this script as with any Model changes
|
|
|