Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>As other commenters have suggested, you probably don't want to start a new Team Project Collection for this purpose.</p> <p>The normal reasons against creating a new TPC are:</p> <ol> <li>Sharing code or work items between two Team Project Collections is very difficult. It's almost as if you're connecting to a new server.</li> <li>Unless your project is so big, that you might need to move the collection to it's own SQL server in the future, there's not a lot of value in a new TPC</li> </ol> <p>However, if you did decide that you want to create a copy of an existing TPC on the same server, these are the general steps to follow:</p> <ol> <li>Open the TFS Admin Console, go to Team Project Collections</li> <li>Select your existing collection and choose 'Detach Collection'</li> <li>Wait for the detach to complete. This procedure copies the "shared" data out of the configuration database (like groups/identities) and stores it in the collection database.</li> <li>Once the detach is complete, backup the databse in SQL</li> <li>In the admin console, choose 'Attach collection' and choose the database that you just detached &amp; backed up</li> </ol> <p>These steps can then be performed on the same server (or another server, if you want to move it there)</p> <ol> <li>Restore the database backup, with a new database name</li> <li>In the TFS Admin Console, choose 'Attach collection' and choose the database that you just restored.</li> <li>TFS will look at the GUID of this database (stored as an extended property), it will see that it is the same as a currently running collection on the server, and automatically give it a new GUID.</li> <li>At this point, you should have two collections running.</li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POTeam Foundation Server: Cloning a Collection's Project into a new Collection
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USGrant Holliday
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POTeam Foundation Server: Cloning a Collection's Project into a new Collection
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan this method be used to create a duplicate collection for testing?
      singulars
      1. PO
      1. USMrHinsh - Martin Hinshelwood
    2. COWell we did end up just creating a new collection and lost history, but this is a very useful post.
      singulars
      1. PO
      1. USyourbuddypal
    3. COUsing TFS 2010 with SQL Server 2008 and creating the new TPC in the same SQL Instance, I arrived at two collections. However the new collection was stopped. The TFS Admin Console prevented starting the new collection because the new and old had projects with the same name and that is not allowed. See the docs on Splitting a TPC that confirm.
      singulars
      1. PO
      1. USsubsci
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload