This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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.
@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.
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.
@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?
@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.