From: Sylvain Lafontaine on 17 Feb 2010 13:47
If you want to constantly switch between these two versions, maybe the
synonyms feature of SQL-Server could help you; see:
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
"allanc" <allan.for.g.groups(a)gmail.com> wrote in message
>I am not totally familiar with the proper terminology and I really
> appreciate help with the following problem:
> My two databases, originally from a third party, have over 250 stored
> procedures each.
> I have changed about 150 of them in one database.
> Due to the testing and implementation requirements of the application,
> I need to save these stored procedures from the one database, restore
> the two databases according to what I received from the third party,
> and then implement my stored procedure changes onto the two restored
> Any suggestions as to easiest and most foolproof method of performing
> these steps are appreciated.
> Thank you in advance.