From SQL SERVER TO MSDE

i have an access application based on sql server
now i was told that for small offices msde is enough and chiper
if it is so can somebody tell me
how to convert the database from sql to msde?
and it cost a lot of code working?
thanks ahead
sam
hi Sam,
Sam wrote:
> i have an access application based on sql server
> now i was told that for small offices msde is enough and chiper
> if it is so can somebody tell me
> how to convert the database from sql to msde?
> and it cost a lot of code working?
MSDE has some constraints built in it, but it is the very same engine as SQL
Server is... so you do not have to worry about "converting" SQL Server
databases into MSDE databases as they are the same...
MSDE has a limit on the file size it's databases data file(s) can reach,
that's to say 2gb per database data files...
other limits are about missing feature, like Full Text indexes, olap
features, partial replication, and so on... but as long as you "stay" into
the architectural limits and your applications do not cover missing features
you will be ok.. further info at
http://www.microsoft.com/sql/msde/pr...o/default.mspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply