I have a instance with many databases in it.
due to company/product name change,
I want to search for a string "xyz" in
database name,
table name,
column name,
stored procedure name
content of all stored procedures
and replace all of them with "abc" without affecting the databases an application.
Can u please help me with step by step guidance?
muralidaran rYou want to change the names of things without affecting an application that uses this data?
Slow down and think about what effects this will have.|||hi
thanks for your reply
the only change expected from application is the change of connection string.
Muralidaran r|||Your application doesn't do anything like
SELECT Field1 FROM xyzTable
?|||My application code never uses table name or column name.
it uses only stored procedure names.
muralidaran r|||I want to search for a string "xyz" in
database name,
table name,
column name,
stored procedure name
content of all stored procedures
I rest my case.|||If your application calls stored procedure names have "xyz" in them, then there is no solution to your problem... When you rename the called procedures, the application will fail (because it will still try to use the old names that contain "xyz" instead of "abc").
-PatP|||due to company/product name change,
Can u please help me with step by step guidance?
Sure, learn how to code correctly|||Thank you guys. Now I will retype the question. try to understand better. Actually the coding was done by someone else and now i have to manage this. OK. try to give a solution.
I have a instance with many databases in it.
due to company/product name change,
I want to search for a string "xyz" in
database name,
table name,
column name,
content of all stored procedures
and replace all of them with "abc"
Can u please help me with step by step guidance?
muralidaran r|||It shouldn't be done IMO.
Users don't see database name(s), table names, column names or content of stored procedures. Users should only see data that you let them see.|||How to search for a string "xyz" in
database name,
table name,
column name,
content of all stored procedures
muralidaran|||I want to search for a string "xyz" in
...
and replace all of them with "abc"
I did listen and I responded appropriately. My advice is don't do it, simple as that.
As always you can chose to ignore my advice but I can assure you that others will respond in a similar fashion.|||Hi
Already i started changing the string by some manuall method which is tedious and hard.
at each and every stage i am checking the applications performance and accuracy.
I need help to speed up this.|||Speaking from a SQL2000 perspective, you need to check "name" in sysobjects for tablenames, view names, proc names, etc. You need to check text in syscomments for sproc content, etc, you need to check syscolumns for column names, etc.
I'm sure for every place you catch, there will be 2 you don't catch.
I'm with GeorgeV, DO NOT DO IT. Let sleeping dogs lay.
Have fun.|||Dear muralidaran_r,
Have you understood what the users here are telling you?
If you change a table name from xyzMyTable to abcMyTable, then all views, triggers, procedures functions, client side calls etc must be modified to point to the new name.
Or are you asking how to search for and change data stored in the tables?|||muralidaran,
Script your entire database to a single text file. Do a search and replace in that text file, and then run the script against a new empty database, as I am sure there will be many errors that occur and that will need to be fixed.|||muralidaran,
Script your entire database to a single text file. Do a search and replace in that text file, and then run the script against a new empty database, as I am sure there will be many errors that occur and that will need to be fixed.
....or, find another career|||"If you change a table name from xyzMyTable to abcMyTable, then all views, triggers, procedures functions, client side calls etc must be modified to point to the new name"
Yes to modify all, is there any automated method, tool, procedure available.
Muralidaran r|||No, not that I know of.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment