plsql (PL/SQL) Integrated Team Foundation Server (TFS) for version management of database code

PL/SQL is an integrated development environment for oralcle databases and is the primary tool for many Oracle database developers. Because PL/SQL (Baidu Encyclopedia) is not only a kind of language, but also a process programming language, in the project implementation process, will accumulate a large number of other than stored procedures code. Since there is code, the code must be versioned, to implement code changes in the traceability and backup, which is the basic requirements of the software development process. An enterprise that uses Team Foundation Server (TFS) as the Application Lifecycle Management (ALM) platform for teams naturally requires integrated development between TFS systems and Plsql. In this blog, I mainly describe the software environment that Plsql connects to TFS Systems and the best practices for database Scripting/code versioning with Plsql integration with TFS.

First, the necessary conditions

• MSSCCI

Msscci can integrate TFS with development tools that do not support Team Explorer, so that these development tools can be combined with TFS to implement source code versioning. Msscci is actually a collection of TFS APIs that enable developers to connect to TFS servers by invoking their interfaces and implement the same code management capabilities as the team free manager. In addition to non-Microsoft third-party development tools can integrate MSSCCI, in fact, many older versions of Visual Studio (such as Visual Studio 2005) need to integrate it later to connect to the TFS server. You can download Msscci from the Visual Studio marketplace from the following address.

Https://marketplace.visualstudio.com/items?itemName=TFSPowerToolsTeam.MicrosoftVisualStudioTeamFoundationServer20132015M

• PL/SQL Version control plug-in

If you already have a CVS menu in your Plsql Developer development tool, you don't need to download and install the plugin. Otherwise, please download and install it at the following address: Http://www.allroundautomations.com/download/vcs124.zip

• TFS Team Explorer (TFS TE)

TFS Team free Manager is a native client program for TFS servers and a streamlined version of Visual Studio that enables source control, work item management, production management, and more. You can download the version of TFS 2013 by using the following address: https://www.microsoft.com/en-us/download/details.aspx?id=40785. Because TFS 2015 does not publish the corresponding TFS TE version, the latest TFS TE does not support Msscci, and you can only download version 2013. Fortunately, after testing, the 2013 release of the team free manager supports TFS 2017.

Second, installation and configuration 1. Install PL/SQL

Plsql installation is basically a fool-style, do not have to explain. Need to explain that, after the installation is complete, random to search a serial number activation software, there are many online.

2. Installing the Oracle Client

An Oracle client is a prerequisite for plsql to connect to an Oracle server.

After the installation, you can refer to the following methods, the data server related information configuration in the Tnsnames.ora file, you can also need to connect in the Plsql in the direct input.

1. Add an environment variable named Tns_admin and the value is the path where the Tnsnames.ora file is located.

(such as: C:\Ora10InstantClient, especially after reloading or other operations, forget the tns_admin variable, plsql login will be reported cannot parse the specified connection identifier),
This is to be able to find the Tnsnames.ora said above. If Oracle is installed on this machine and the ORACLE_HOME environment variable is set,
Then the Tnsnames.ora file is automatically found in the%oracle_home%/network/admin/location.

2. Configure the server connection information, that is, the contents of the configuration Tnsnames.ora, examples are as follows:

Ecifdb_test = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = XXX.XXX.XXX.XXX) (PORT = 1521)) (Connect_data = (server=dedicated) (service_name = mytestdb) (instance_name = Mytestdb ) ) )

3. Download and install the source code plugin

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

4. Download and install the MS Visual Studio2013 team free Manager

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

5. Download and install TFS MSSCCI Provider 32-bit

Https://marketplace.visualstudio.com/items?itemName=TFSPowerToolsTeam.MicrosoftVisualStudioTeamFoundationServer20132015M

Iii. PL/SQL code version Management Practice 1. Connecting to an Oracle database

Use Plsql to connect the database I configured above. If you don't need to debug your SQL scripts online, you can click Cancel.

2. Connecting to a TFS server

In PL/SQL, select Open Project to connect to the TFS server. Project here can be understood as a directory where the code is stored on the server.

Select the code path on the TFS server and specify the local path. The local path is the working path of PL/SQL.

3. Check out

PL/SQL automatically downloads and opens checked-out data script files from the server, and you can develop edits and debug your scripts.

4. Check In

After you have completed code editing and debugging, you can check in the modified code directly in Plsql.

Select the file in the check-in, fill in the check-in memo information, for example I wrote here "This is Zhang Hongjun test check-in code in PL/SQL"

People who have used TFS systems should be familiar with the following, where you can choose which files to check in, modify comments, manage work items, and so on.

is to view the files that are checked in successfully on the TFS server:

(Microsoft ALM MVP Zhang Hongjun http://www.cnblogs.com/Zhanghongjun)

5. Other

-In addition to the typical check-in, check-out, you can use other versioning features, such as Undo, new (add), and so on, these are relatively simple, to explore their own.

-Reference: https://blogs.msdn.microsoft.com/dpe_nigeria/2013/09/29/ msscci-magic-integrate-oracle-plsql-developer-with-team-foundation-server/

plsql (PL/SQL) Integrated Team Foundation Server (TFS) for version management of database code