Shulou(Shulou.com)06/01 Report--

For traditional large-scale software products using relational database, continuous development and maintenance of background database may produce a large number of script files. How to conveniently manage the version of these script files and how to quickly manage the permissions among teams? Different database products and corresponding client management tools may have different degrees of integration with different product version management tools.

By recording the installation, configuration and operation of TFS, PL/SQL and corresponding plug-ins, this paper realizes a version management mode of database script.

1. Environment and plug-ins

The following plug-ins are required to implement version management integration between PL/SQL tools and TFS

PL/SQL Developer plug-in, download address:

http://www.allroundautomations.com/download/vcs124.zip

TFS MSSCI Tool, download address:

http://visualstudiogallery.msdn.microsoft.com/06c8e056-7f77-4a5c-9b8b-49318c143df8

TeamExplorer tool (ignore if VS2013 and later are installed), download at:

http://www.microsoft.com/en-us/download/details.aspx? id=39314

2. TFS parameter configuration in PL/SQL

The above installation packages are very simple, just click a few steps, after completing the installation of the above software, open PL/SQL tools, you can see the toolbar added VCS menu. Click VCS -> Open Project to open the TFS parameter configuration dialog box shown below.

Click the Open Folder button in the Project input box, select TFS Server and Project and specify the local working directory

3. Check-in and check-out of script files in PL/SQL

Create a new script file, which must be placed under the local workspace directory set up in the previous step.

Click CVS -> Add, select the newly added file and check it into the TFS repository.

You can see the code you just checked in in TFS Portal

Other operations, such as check-out code, historical version comparison and other operations are not listed one by one, these functions are out-of-the-box functions.

4. File permission management description

In a multi-person team, it may involve the need for permission management, such as the need to reasonably solve the problem that people in different roles in different teams have different permissions on files.

I feel that in addition to knowledge rights protection, data security defense, project risk avoidance and other starting points, as far as possible do not waste team members 'time on rights management.

Permission management can satisfy most permission scenarios by combining the areas, folders, files themselves, accounts and permission terms in TFS, and apply permissions to the smallest granularity of management objects. The following is an interface for file permissions configuration.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.