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

Question

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

Richard Arnold 181

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.

Accepted answer

1 additional answer

Your answer

Answer 1

CathyJi-MSFT 22,396 Microsoft External Staff

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.

Richard Arnold 181 Reputation points

2021-04-01T16:10:48.423+00:00

@CathyJi-MSFT Yes, I came across this same site a few days ago. What I think I need to do, is refer to the older product and package.xml files from SqlExpress2012 and create a new product.xml and package.xml, using the previous files to update the information in the new files to reflect SqlExpress2019.

I still wish I had copies of the files that would be for a full install of SQL Server 2019 Express, but this will have to do. Thank you for your assistance.

Answer 2

CathyJi-MSFT 22,396 Microsoft External Staff

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

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

Richard Arnold 181 Reputation points

2021-03-31T13:40:51.667+00:00

@CathyJi-MSFT When I navigate to the above directory, it lists "SqlLocalDB2019". However, I am NOT using a LocalDB for sql 2019 express.
Therefore, I don't feel that product.xml and package.xml file would be the correct one to use for deployment.

I installed SQL Server 2019 Express on my system, using the file "SQL2019-SSEI-Expr.exe". This was to upgrade my existing sql install of SQL Server 2012 Express, which again, does Not use a LocalDB.
The file I wish to incorporate in the ClickOnce deployment is "SQLEXPR_x64_ENU.exe" Referencing the path you provided, how would the product and package xml files for SqlLocalDB2019, be correct for deploying the more complete database install?
Richard Arnold 181 Reputation points

2021-03-31T18:40:21.173+00:00

@CathyJi-MSFT From researching the difference between SQL Server, this is what I found. SqlLocalDB is different from the full install of SQL Server 2019 Express, as shown from the links below. LocalDB is a lightweight deployment option for SQL Server Express Edition with fewer prerequisites and quicker installation.
LocalDB has all of the same programmability features as SQL Express, but runs in "user mode"* with applications and not as a service.
LocalDB is not intended for multi-user scenarios or to be used as a server. (If you need to accept remote connections or administer remotely, you need SQL Server Express.)

[is-there-a-difference-between-sql-server-express-2012-and-localdb][1]
[sql-server-express-vs-localdb.html][2]

SQL Server Express vs LocalDB, Not the same thing.

Share via

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

1 additional answer

Your answer