Settings and activity

2 results found

1. Get specific version from source control (SVN: Update to revision)

   189 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   10 comments  ·  SQL Source Control  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   under review  ·  Kendra responded

   While SQL Source Control provides a way to view object history, it does require additional tooling to update your database to a specific version from history.

   We currently have documentation on how this works here: https://documentation.red-gate.com/soc/common-tasks/update-to-a-revision-from-source-control

   Paul Jenkins supported this idea  ·  Sep 14, 2011

2. SQL Source Control Static Views (or Table Subsets using WHERE clause)

   633 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   30 comments  ·  SQL Source Control » Static Data  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   under review  ·  AdminStephanie (Product Manager, Redgate) responded

   Hi,

   
   

   We just added this capability to Flyway, which is our x-database, x-OS cloud- and Git-first Database DevOps solution for versioning and deploying database changes. You can learn more about this feature in Flyway at https://documentation.red-gate.com/fd/working-with-data-138347109.html#Workingwithdata-Controllingstaticdata.

   
   

   You can also import your SQL Source Control repos into Flyway while keeping your Git history. Learn more about moving to Flyway and importing your project at https://documentation.red-gate.com/fd/transitioning-from-other-redgate-tools-164167855.html.

   
   

   If you have any questions, please comment below or reach out to us at DatabaseDevOps@red-gate.com.

   
   

   Thank you!

   Stephanie Herr

   Product Manager - Database DevOps

   An error occurred while saving the comment
   Paul Jenkins commented  ·  Sep 14, 2011  ·  Edit…  ·  Delete…

   I don't know of an orgranization that does not require audit columns on all of their lookup tables (static data). Not having the ability to do this makes the static data mechanism useless for organizations with auditing standards.

   Save Submitting...
   Paul Jenkins supported this idea  ·  Sep 14, 2011