Home > Archive > MS SQL Server > October 2006 > Creating SQL Server CE database on server









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Creating SQL Server CE database on server
Chris Karcher

2006-10-24, 6:38 pm

Is it possible to create a SQL server CE 2.0 database on a desktop
running SQL Server? We're currently building the database on the device
itself but would like to prebuild it on the server and just send it
down. Microsoft describes something in:

http://support.microsoft.com/defaul...;301217&sd=tech

This really seems like just a hack.

You can create the databases on the PPC emulator, so I didn't think it
would be too far of a stretch to create them on the server.
Hilary Cotter

2006-10-24, 6:38 pm

the really great news is you can create it on the desktop/server in SQL
2005! However, the method described in the link you have provided is the way
I have always done it.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Chris Karcher" <ckarcher@mail.utexas.edu> wrote in message
news:ehb1c8$7k9$1@ge
raldo.cc.utexas.edu...
> Is it possible to create a SQL server CE 2.0 database on a desktop running
> SQL Server? We're currently building the database on the device itself
> but would like to prebuild it on the server and just send it down.
> Microsoft describes something in:
>
> http://support.microsoft.com/defaul...;301217&sd=tech
>
> This really seems like just a hack.
>
> You can create the databases on the PPC emulator, so I didn't think it
> would be too far of a stretch to create them on the server.



Chris Karcher

2006-10-24, 6:38 pm

Yea, it's really cool that SQL Mobile (Everywhere?) can be used on all
platforms. It's just that we aren't quite ready to switch yet..

Hilary Cotter wrote:
> the really great news is you can create it on the desktop/server in SQL
> 2005! However, the method described in the link you have provided is the way
> I have always done it.
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com