Sanitize command separate from sql-sync

[jeff-h]

I think it would be useful to be able to sanitise a site without having to sql-sync. For example, let's say I have 30 compressed database backups (not sanitised — they're backups) and I want to use one on my dev site. I don't want to hit the live site for a fresh dump using sql-sync as that's heavy on the server.

To get this into my dev unsanitised I simply do:

gunzip -c myfile.sql.gz | drush @dev sqlc

To do this sanitised I have to use sql-sync, which has two problems:

a) can't take a gzipped dump file, so I have to gunzip it first somehow

b) needs me to

drush sql-sync @dev @dev

which is counterintuitive and seems to be redundantly dumping @dev to an .sql file then restoring it straight back, which takes quite a while on a large db.

I would love to be able to do:

gunzip -c myfile.sql.gz | drush @dev sqlc && drush @dev sanitize

[msonnabaum]

We actually already have drush sql-sanitize, it's just hidden from help.

We should probably just unhide it.

[weitzman]

I have no strong feeling on unhiding. We discussed this at https://drupal.org/node/1112142

[jeff-h]

Awesome! I searched the codebase before posting but missed it. Grr.

Would be a great one to unhide (from my perspective anyway).