[user512]

Does anyone have any info on how to search an SQL file? Some can be opened using text editors but others are far too large.

[Dev]

On Windows,
You can use EmEditor, Lister, LTF Viewer

https://www.ghisler.com/lister/
https://www.portablefreeware.com/?id=693

On linux, you can use grep.

[user512]

I'll have to check out grep. I feel like I have seen/used it. Notepad++ has been useful but I've run into insufficient memory problems lately. I'd be surprised if a windows environment was better for SQL analysis, to be honest.

Thanks for listing though, that gives me a lot to work with.

When would you set up your own mysql or postgres server? I was under the impression I'd have to essentially connect the sql file to a server somehow.

[dense]

use a few things but in general just basic tooling or grep out what I need

This forum account is currently banned. Ban Length: Permanent (N/A Remaining)
Ban Reason: Leeching | http://c66go4clkqodr7tdjfu76jztjs7w7d3fajdeypxn73v4ju3dt7g5yyyd.onion/Forum-Ban-Appeals if you feel this is incorrect.

[user512]

So if you wanted to automate a way of comparing multiple sql files, would that be a server requirement?

[curry536]

So if you wanted to automate a way of comparing multiple sql files, would that be a server  requirement?

no,, use command line in linux, powershell in windows, or wsl in windows,,, no need 4 server

create scripts for this,, ripgrep is very good and fast for wsl/linux,, also you can import into mysql database on yur machine

[user512]

Thanks for that information. I'll have to do some googling for commands. 

So if you wanted to automate a way of comparing multiple sql files, would that be a server  requirement?

no,, use command line in linux, powershell in windows, or wsl in windows,,, no need 4 server

create scripts for this,, ripgrep is very good and fast for wsl/linux,, also you can import into mysql database on yur machine