dbForge Data Compare allows searching and replacing open SQL documents and the files saved on your hard drive using the Find and Replace window. To open it, navigate to the Edit menu and select Find and Replace > Replace in Files.
In the Find and Replace window, type in the keyword you are looking for.
Specify the keyword that will be used to replace the search results.
Select the Include sub-folders if needed.
To choose search folders click Browse in the Look in field. The Choose Search Folder window opens:
1. To open a folder, simply double-click it.
2. To select or remove a particular folder, use the corresponding controls.
3. The interface also allows you to choose the recently opened folders from the dropdown menu.
4. navigates you one directory up.
5. In case you would like to keep this particular set of folders for further use, you can save it under a custom name by clicking Apply. There can be more than one predefined set of folders. To remove a previously saved folder set, click Delete:
The Find options include:
Match case
If this checkbox is selected, the search results will only contain the text from the Find what box matched both by content and by case.
Match the whole word
If selected, the search results will only contain the instances of the string specified in Find what that are matched in complete words.
Use
Determines how to treat the special characters entered in the Find what box. There are two options: Regular Expressions and Wildcards.
Choose the file extension you are looking for:
The Result options include not only Display file names only but also the Keep modified files open after Replace All option.
Clicking Find Next allows you to view one search result at a time.
To reverse Replace All, select Undo from the Edit menu in each changed file before closing any of the files.