Microsoft Database
May 14, 2019

Microsoft Database

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

We currently use Microsoft SQL Server, integrated with Automation Anywhere, to develop automation scripts. We opted for SQL Server for its Microsoft support and native Automation Anywhere functions that allow us to work with this Database.

Pros

  • SQL Server, because it is Microsoft, has the support of the company, and it is possible to integrate with thousands of applications that run on windows.
  • The price of the paid version of SQL Server is well below the market average, although we do not lose in quality.
  • It allows the developer to use a managed programming language, such as C # or VB.NET, to address queries, rather than using SQL statements.

Cons

  • The main point that displeased me most in SQL Server 2008 is the lack of intelligence of the tools.
  • Since Microsoft decided to support the creation of stored procedures and other database objects in .NET framework languages it seems that T-SQL has been a bit sideways.
  • Difficult to mount a cluster, mirroring, replication...
  • The return by using SQL Server, for us, is more due to the use of the Automation Anywhere tool.
As SQL Server is from Microsoft, it is more feasible for the less experienced developer to start working with Database in SQL Server, but currently, we only use the tool because of its integration with Automation Anywhere. If we could, we would choose another.

Comments

More Reviews of Microsoft SQL Server