question

RichardArnold-1221 avatar image
0 Votes"
RichardArnold-1221 asked RichardArnold-1221 commented

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

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-generaldotnet-csharp
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
1 Vote"
Cathyji-msft answered RichardArnold-1221 commented

Hi @RichardArnold-1221,

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered RichardArnold-1221 published

Hi @RichardArnold-1221,

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.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Cathyji-msft When I navigate to the above directory, it lists "Sql*LocalDB*2019". 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 Sql*LocalDB*2019, be correct for deploying the more complete database install?



83257-clickoncepath.png


0 Votes 0 ·
clickoncepath.png (10.2 KiB)

@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.


0 Votes 0 ·