Forum Discussion

tbeck's avatar
tbeck
New Contributor
11 years ago

[CodeReviewer] Updating Next Review Number


Hi,

 



We're migrating to a new instance of CodeReviewer and for business purposes we've had to abandon the data from the old instance.  However, we'd like to start the review numbers on the new system from where we left off on the old system.   Is there a way to update the system so that it creates the next review with  number 1000 (for example)?

 



Thanks

Tim

 


1 Reply

Sort By
  • tbeck's avatar
    tbeck
    New Contributor
    11 years ago


    I figured this out.  Head to download sqltool and use that to get access to the database. 



    Then I could do:



    alter table review alter column review_id restart with 1000

     



    Tim