Toolbelt Software
The United States Army Medical Research Acquisition Activity (USAMRAA)
has a requirement for the United States Army Medical Research Institute of Infectious Diseases (USAMRIID) for toolbelt software.
This is a Request for Quotation (RFQ). The solicitation document and
incorporated provisions and clauses are those in effect through Federal
Acquisition Circular (FAC)2001-27. This requirement is unrestricted. The North American Industry Classification System (NAICS) code
is 511210 with a size standard of $35.5 million. This code shall be listed in
System for Award Management (SAM.gov) prior to award.
The following are the Minimum Essential Characteristics (MECS) for the
requirement:
1. Must have Plug-in that connects a source control system to SQL Server Management Studio. Ability to
Link database to:
a. SVN
b. Vault
c. TFS
d. Perforce
e. Git
f. Mercurial
2. Must have the ability to Compare and synchronize SQL Server database schema
a. Generate T-SQL scripts that update one SQL Server database to match the
schema of another
b. Find and fix errors caused by differences between databases
c. Compare and synchronize within SQL Server Management Studio
d. Deploy to SQL Azure databases or SQL Server on Amazon RDS
3. Must have the ability to Compare and synchronize SQL Server database contents
a. Copy lookup data from development databases to staging or production
b. Generate T-SQL scripts to update one database with the contents of another
c. Quickly fix problems by restoring damaged or missing data to a single row
d. Keep an accurate history of all previous database records
e. Compare and synchronize data within SSMS
f. Deploy to SQL Azure databases, or SQL Server on Amazon RDS
4. Must have the functionality to Write, refactor, and explore SQL
a. save, search, and recover tabs in SSMS
b. IntelliSense-style code
c. Customizable code formatting
d. Save code snippets
e. Refactor SQL code
5. Must be able to Generate realistic test data fast, based on column and table names
a. Create large volumes of data within a couple of clicks in SQL Server
Management Studio
b. Generate meaningful test data at row level
c. Shareable custom generators - save regexp and SQL statement generators to share
with your team
d. Column-intelligent data generation - generate data in one column based on the
data in another
e. Flexibility and manual control for creating foreign key data
6. Must be able to Explore object dependencies and visualize complex databases simply
a. Quickly understand the database by graphically tracking database object
dependencies
b. Rapidly document database dependencies for archiving, reporting, version
control, and auditing
c. Quickly visualize areas of complexity with dependency diagrams and text-based
dependency checker
d. Track dependencies between several related databases in the same diagram and
project
e. Find potential orphans with no dependencies on other objects, to help clean up a
database
7. Must be able to Compress, securely encrypt and strengthen backups
a. Step-by-step wizards and a centralised GUI take the legwork out of creating, restoring, and
verifying your backups.
b. Protect against backups failing due to network outages.
c. Secure your backups with up to 256-bit AES encryption, compressing them at the same time, even
from an unencrypted database.
d. Automate more than just taking backups, including backup verification, scheduled restores, and
log shipping.
e. Save storage space, speed up network file transfer, and get higher levels of compression than
native SQL Server.
f. Let backups verify themselves. Schedule regular restores, and include an essential database
integrity check (DBCC CHECKDB).
8. Must have SQL Server performance monitoring and alerting
a. Web-based monitoring, available from any device
b. Real-time performance data and alerts
9. Must be able to Search database quickly in SQL Server Management Studio
a. Find fragments of SQL text within stored procedures, functions, views and more
b. Quickly navigate to objects wherever they happen to be on a server
c. Find all references to an object
10. Must have the ability to Automatically generate database documentation
a. Satisfy audit requirements by keeping complete documentation
b. Document a database in a couple of clicks, from within SSMS
c. Distribute documentation
11. Must be able to Package databases as an .exe for deployment or update
a. Script and compress schema and data accurately and quickly into a deliverable
.exe file
b. Easily roll out database updates across the client base
c. Package any pre-existing SQL script as a .exe, or launch as a C# project
d. Simplify deployments and updates
e. Supports all objects in all versions of SQL Server, including SQL Server 2012
12. Must be able to Deploy multiple scripts to multiple servers with just one click
a. Deploy multiple scripts on multiple servers with just one click
b. Query databases in parallel
c. Save time with aggregated results for easy analysis
d. Edit queries fast with an intuitive interface
e. Cut out repetitive administration
13. Must provide the ability to Develop databases in Visual Studio alongside application cod
a. Develop databases in Visual Studio alongside application code
b. Query databases and execute stored procedures directly from Visual Studio
c. Track and share changes using your source control system
14. Must be able to Write and run unit tests in SQL Server Management Studio
a. Write your tests in regular T-SQL
b. Tests won't change your database
c. Test objects in isolation - no need to worry about keys or IDs
d. Includes example unit tests and SQL Cop
e. Run as many tests as you want with one click
15. Must have the ability to Automate comparison and synchronization tasks
a. Schedule database comparison and synchronization
b. Migrate and deploy schema and data changes
c. Build Red Gate comparison and synchronization functionality into their own
applications
d. Automate tasks using the new Sequence object type, File Tables, and
Columnstore Indexes in SQL Server 2012
16. Must be able to Recover database objects from SQL Server backups
a. Recover individual database objects from native SQL Server backups
b. Save time and disk-space over restoring full database backups
c. Licensed per user for more flexibility
d. Compatible with SQL Server 2008, 2005 and 2000
17. One year of support and upgrades
All responsible sources may submit a quote, which shall be considered by the
agency. The competitive solicitation, solicitation amendments and all
questions and answers relating to this procurement shall be made available
via the Internet at https://acquisition.army.mil/asfi/ or
https://www.fedbizopps.gov. The solicitation is anticipated for release to the
vendor community on or about May 19, 2014, and will only be available until
May 27, 2014. Specifications of the requirement are provided in solicitation:
W81XWH-14-T-0209.
Potential offerors are responsible for accessing the website. Interested parties
must respond to the solicitation in order to be considered for award of any
resultant contract. To be eligible for an award, offerors SHALL be registered in
the System for Award Management (SAM.gov) and have completed its
representations and certification completed via SAM.gov. Contractors may
obtain information on registration and annual confirmation requirements via
www.SAM.gov.
All questions should be addressed in writing to Jennifer Hayden, Contract
Specialist at [email protected]. No questions will be accepted
after 4:00pm EST May 22, 2014.
All interested parties shall provide their quote to Jennifer Hayden at
[email protected] by 12:00 p.m. EST on May 27, 2014 in order to
be considered for this solicitation.
Jennifer Hayden, 301-619-1363
US Army Medical Research Acquisition Activity
