Sql-server – How to generate TPC-DS query for sql-server from templates

benchmarksql server

I know that dsqgen is used to transform the query templates into executable SQL. But when I type in the command line: "dsqgen /directory query_templates /template query1.tpl /dialect sqlserver /scale 5", there's an error that "Substitution 'STATE' is used before being initialized". I also copied the ansi.tpl and tpcds.idx files in the same directory as dsqgen.exe because dsqgen always read these two files. Anyone has any idea how can I solve this? Thanks in advance.

Best Answer

You can download fix error "STATE" and endcoding dump data to database at https://github.com/grahn/tpcds-kit

Related Solutions

Postgresql – How to generate TPC-DS queries for PostgreSQL

Not sure about the TPC-DS, but I know that HammerDB will perform a TPC-H(ad hoc DSS) benchmark test against PostgreSQL. If you're looking for a benchmark, but not specifically a TPC-DS, this is a good tool for testing.

SQL Server 2012 – How to Generate Scripts from Command Line

Best is to use Powershell - if you are going to use it frequently. You can refer to Automated Script-generation with Powershell and SMO.

Also, SQL Server PowerShell Extensions (SQLPSX) are of great value when working with Powershell. All the modules are having help files e.g. Get-SqlScripter.

Get-SqlDatabase -dbname database1 -sqlserver server | Get-SqlTable | Get-SqlScripter | Set-Content -Path D:\scripts\script.sql
Get-SqlDatabase -dbname database1 -sqlserver server | Get-SqlStoredProcedure | Get-SqlScripter
Get-SqlDatabase -dbname database1 -sqlserver server | Get-SqlView | Get-SqlScripter

For third party tools, highly recommend to check out (there are many third party tools out there, but below ones I have used and they are great):

Redgate's SQL Compare and Data Compare
SSMS Tools Pack by Mladen Prajdić

Best Answer

Related Solutions

Postgresql – How to generate TPC-DS queries for PostgreSQL

SQL Server 2012 – How to Generate Scripts from Command Line

Related Question