Any way to automate the same change in a large no. of SQL scripts?

Question

virtualmisc 0 Junior Poster in Training

14 Years Ago

Hello Friends

I wanted to make a same change in over 300 SQL scripts. Is there a way to automate this?

Thanks

mssql

2 Contributors
1 Reply
86 Views
1 Day Discussion Span
Latest Post 14 Years Ago Latest Post by samaru

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

samaru 145 a.k.a inscissor Team Colleague · Answer 1 · 2010-02-24T07:20:29+00:00

If you have them in your DB, export as TSQL scripts - a TSQL script file per object (sproc/table/etc). Get a file search and replace program (http://www.thefreecountry.com/programming/searchandreplace.shtml) and run through it.