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: 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. >
First
|
Prev
|
Pages: 1 2 Prev: Calculate maximum connections during a day Next: Problem installing SQL Server Express 2008 |