From: Sylvain Lafontaine on
If you want to constantly switch between these two versions, maybe the
synonyms feature of SQL-Server could help you; see:
http://www.developer.com/db/article.php/3613301/Using-Synonyms-in-SQL-Server-2005.htm

--
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
(French)


"allanc" <allan.for.g.groups(a)gmail.com> wrote in message
news:0fb74c8a-a0ff-4a1d-90c9-6afd1533c968(a)i39g2000yqm.googlegroups.com...
>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
> databases.
>
> Any suggestions as to easiest and most foolproof method of performing
> these steps are appreciated.
>
> Thank you in advance.
>