Empty AdventureWorks database

[Sergii]

Hi,

after installation of Telerik Reporting (with examples option checked) I got installed AdventureWorks database, but it is empty and I can't run any example report without data.

Where can I get backup of AdventureWorks database with data ?

[Todor]

Hi Sergii and Krasimir,

The AdventureWorks database we use for our examples is older, and we keep it for the backup compatibility of our demo reports.

Therefore, we provide the SQL script for creating this sample database with the installation of the Reporting product.

The default location of the SQL is the folder "C:\Program Files (x86)\Progress\Telerik Reporting 2025 Q3\Examples\Data\AdventureWorks OLTP\". Note that the version (2025 Q3) may vary. You need to run the script "instawdb.sql" in the SQL Server Management Studio to restore the database and use it with our examples. The CSV files in the same folder represent the actual data tables.

Regards,
Todor
Progress Telerik

[Krasimir]

Hello,

I'm also using AdventureWorks as a reference DB for samples and trainings. You can download it from here -> https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver17&tabs=ssms

The link provides the backups of the DB. You can follow the instructions in order to restore the DB.

Regards,
Krasimir Baylov

[Sergii]

Microsoft db has different structure

[Krasimir]

Hello Sergii,

Can you provide an example for some of the differences? I have AdventureWorks and AdventureWorks2022 locally and they seem to work fine with the samples.

Can you confirm you can connect to the DB through Telerik Reporting? What kind of error do you see? Can you create a new simple report that is using the DB, just to confirm that the problem is not related to connectivity?

Regards,
Krasimir Baylov

[Sergii]

Hello Krasimir,

structure differences (compared with Visual Studio):

 

>Can you confirm you can connect to the DB through Telerik Reporting?

Yes

What kind of error do you see?

>Can you create a new simple report that is using the DB, just to confirm that the problem is not related to connectivity?

sql query:

SELECT TOP (1000) [DepartmentID]
      ,[Name]
      ,[GroupName]
      ,[ModifiedDate]
  FROM [HumanResources].[Department]

 

 

Best r

egards,
Sergii

 

[Sergii]

Hi Todor,

first of all thank you for wide and detail answer.

FYI: My issue with empty database happened because I use MSSQL in cloud (Azure) or inside docker as linux container, but script intended to be ran on Windows host with standalone mssql or sqlexpress. In corporate network not always easy to find such configuration.

 

Thanks again

Sergii