How to include MS SQL Compact in Basic MSI?

[vnikolov]

I have basic MSI project and I need to include MS SQL Compact SP1 in it.
I still need to produce MSI package at the end.
Is it possible to include the SQL CE in it? Is it possible to convert it to MSM or some other way?
Regards
Vlad

[yamakamyar]

You can create your own .prq file then select it.

For example for SQL Server Express 2005 we have:







REplace the executable with yours and accordingly change this.

Hope this helps,
Yama