Database Runtime

I am Using Sql Server 2005 enterprise edition to develop an accounting system.
now i want to distribute this software to other cleints.
I have created a setup which includes all the components required for the run time of the software but i dont know how to include the sql server database in it.
as i know that i have created access based software i used to include the database file in the setup and it would work but in the case of sql server i dont know how to do it .
is there any runtime of sql server which needs to be downloaded or any other way out.SQL Server Express is free of charge.|||I just seached information on sql server expres edition. it Is quite good but what if i need my application to run on network.
is it possible in sql server express edition to run my application on network.|||and another thing as i ve created my application in sql server enterprise manager is it possible to convert my database in sql server express edition|||See here for the differncies between Express and Enterprise editions
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Database otpion @ Client - Smart Client

Hello,

We are trying to develop a smart client application which is occasionaly connected. The issue here is we are unable to decide on the database which needs to be used in the client. We will not able to use MSSQL express or MSDE becuase of the size limitation. The size of the DB is actually a couple of gigs(SQL server backup). The user need not do any transaction which needs to be re recorded in server. The user will connect only to donwload data and get the application updates.

The other important factor the user should have high performance of the applciation

Please suggest

I'm not an expert on all of the SQL Express specifications, but according to this, the limit is actually 4GB, so maybe this would work for you:

Comparing SQL Server Express with MSDE

http://msdn2.microsoft.com/zh-cn/library/ms165672(SQL.90).aspx

Thanks,

Sararh

|||

Sorry. I must have told you...I will also have incremental update to the database..so everytime you update the database size is going to grow ...So it will easily cross 4 GB of data over a period of time ...