January 24, 2003 at 9:29 am
Is there a way to transfer stored procedures from one database to another database on a different server.
January 24, 2003 at 10:08 am
I usually script the SPs, then use Query analyzer to apply them to the new server. You also may need to export or apply the grants.
KlK, MCSE
KlK
January 24, 2003 at 11:36 am
The best approach for this would be to use DTS. You can even use DTS import wizard. This will do several things for you. First of all, you will be able to transfer objects, permissions, and depended objects. There are different options when you run DTS import wizard. The option you need is Copy objects and data. Uncheck copy data and uncheck Copy all objects. When you click on objects you will be able to choose what you need to copy. There are other options you can choose
January 24, 2003 at 12:06 pm
This probably more than what you are looking for, but it explains my reasoning. I like DTS it's a great tool, but I prefer to script changes and then apply them. For version control this is safer.
This is my setup
DEV - owned and controlled by the developers. I script from here
Test - apply script. If approv. apply to UAT else back to dev
UAT(bus. owner)- apply script. If approv. apply to SAT else back to dev
SAT(stress) - apply script. If approv. apply to Prod else back to dev
Prod. - apply script.
I like to use source safe to lock down the scripted code. The dev team informs me with a documented list of changes when a release/hotfix is ready. I do a full grab from the dev team and compare the changes since the last grab. If a change has been made but not documented by the dev team a resolution of the changes takes place. I then take just the net differences and apply them as stated above.
John Zacharkan
John Zacharkan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply