It has been a bit since I have worn my SQL hat guys so bare with me. I have over 400 stored procedures that I am migrating from SQL 2000 to SQL 2008. In those procedures an old SQL server name is hard coded. I would like to do a global search
and replace of all those sprocs. Or even better if I could reference a single file for all 400.
I was hoping to find a tool that could do this but have not had luck. The few examples I have found online were not applicable because of the version of SQL we are migrating away from or not documented well enough for me to pull off. [http://www.sqlmag.com/article/tsql3/find-and-replace-keywords-in-stored-procedures]
I can replace all 400 manually if needed, just that by now some kind of search and replace functionality would exist in a SQL Tool. Also, just looking for advice on the matter relative to any potholes in going from 2k to 08.....yes scary...these peeps are
also big fans of access 97...baby jesus save me now.
- Noobtacular out
View Complete Post