1. Home
  2. Docs
  3. FAQ
  4. Using Scripts
  5. How do I revert changes?

How do I revert changes?

All the procedure, function, and view scripts it saves to your version control system are runnable .sql files just as if you had scripted them from SQL Server Management Studio yourself.

Right-click on the target object in Object Explorer and navigate to the VersionSQL->Open Latest from Repo menu item. This will open the most recently-committed version of the object’s script into a new query window, and you can go from there.

If you need an older version, the exact command you’re looking for differs depending on the version control system and utility (e.g. GitHub.com, TortoiseSVN, git command line, etc), but in general to restore a specific revision you’d check out or clone the revision number you’re after then execute the script in SSMS.

Was this article helpful to you? Yes No

How can we help?