Editing a 9gb .sql file
- by CERIQ
Hi.
I've got a "slightly" large sql script saved as a textfile. It totals in at 8.92gb, so it's a bit of a beast.
I've got to do some search and replaces in this file(specifically, change all NOT NULL to NULL, so all fields are nullable) and then execute the darned thing. Does anyone have any suggestions for a text editor that would be capable of this?
The other way that I can see to solve the problem is to write a program that reads a chunk, does a replace on the stuff I need, and then save it to a new file, but I'd rather use some standard way of doing this.
It also does not solve the problem of opening the beast up in sql server management studio to execute the darned thing...
Any ideas?
Thanks,
Eric