product.xml and package.xml files for NON-LocalDB SQL Server 2019 Express

asked 2021-03-31T00:18:17.697+00:00
Richard Arnold 181 Reputation points

I am preparing to use ClickOnce to deploy SQL Server 2019 Express with my application, and need to know where I can find the product.xml and package.xml files for that version of SQL, which is a NON-LocalDB SQL Server 2019 Express install.

I downloaded the SQL Server 2019 Express redistributable, i.e. "SQLEXPR_x64_ENU.exe".

My C# application previously deployed a SQL Server 2012 Express database. However, the product.xml and package.xml files are different and I'm not sure if I can just modify them for this ClickOnce deployment, or even how to do so correctly.

Note that this is Not a LocalDB install of SQL Server 2019 Express.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,473 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
6,919 questions
No comments
{count} votes

Accepted answer
  1. answered 2021-04-01T03:23:25.033+00:00
    CathyJi-MSFT 20,656 Reputation points Microsoft Employee

    Hi @Richard Arnold ,

    Thanks for sharing.

    Please check if below blog could help you.

    ClickOnce Deployment: Customizing SQL Server Express


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.


1 additional answer

Sort by: Most helpful
  1. answered 2021-03-31T07:13:44.687+00:00
    CathyJi-MSFT 20,656 Reputation points Microsoft Employee

    Hi @Richard Arnold ,

    > need to know where I can find the product.xml and package.xml files for that version of SQL

    By default, the path is %ProgramFiles(x86)%\Microsoft SDKs\ClickOnce Bootstrapper\Packages. Refer to MS document How to: Include prerequisites with a ClickOnce application

    en for English

    83202-screenshot-2021-03-31-152232.jpg

    83129-screenshot-2021-03-31-152255.jpg


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.