Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kishoreg
Starting Member
11 Posts |
 Posted - 2010-03-24 : 05:48:37
|
| Hi, We want to deploy the Asp.net application along with Database in client system. Can we embed the database with DLL or EXE or MSI file ? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-24 : 06:19:01
|
The only way I see:http://www.mikeborozdin.com/post/Introducing-Microsoft-SQL-Server-Compact-Edition-(Part-I).aspx
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
kishoreg
Starting Member
11 Posts |
Posted - 2010-03-24 : 06:30:11
|
| But in Sql Server Compact Edition i found the database size limits ti 4GB. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-24 : 06:33:48
|
| You can deploy a database as a Backup file (which has to be restored) or as a Detached file (with has to be re-Attached).You could control the Restore, or Attach, from within your program (after it is installed) if you want to make it painless - i.e. get the user to provide SysAdmin login to be used for the Restore / Attach process, and the name of the Server / Instance to restore/attach to. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-24 : 07:42:32
|
I think kishoreg wants to run a database without SQL Server.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-24 : 07:53:49
|
| Ah, OK. How about installing SQL Express as part of his Application install? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-24 : 08:41:42
|
Express is also limited to 4GB isn't it?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-24 : 13:04:53
|
| Indeed! Half asleep, sorry! |
|
|
|
|
|
|
Database Deploy