Re: Copy a Datbase
- From: "Michael Baltic" <MichaelBaltic@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Jun 2005 10:05:06 -0700
Do you want your application to control this copy at all? If so, then you
are going to have to write some manual code to build the schema and populate
it from a data source. A web service to retrieve the data source will be
needed as well.
Sql Server 2000 code will not directly translate to Sql Server CE!
Are you going to be changing this data? Then you will need a web service to
push the data back up?
Are you going to insert records into the database? Then you will need some
sort of method to insure unique row identifiers. Guid?
If you are just doing a lookup of the database, then RemoteSqlCE is awesome
for copying databases to a mobile device.
--
Staff Consultant II
Enterprise Web Services
Cardinal Solutions Group
"Andreas Schenk" wrote:
> Hi!
>
> there are several ways of syncing sql server 2000 to sqlce
>
> here is a nice tutorial on the ms-website:
> http://www.microsoft.com/sql/ce/techinfo/default.asp
>
> or if you want to use a compnent look for "RemoteSQLCe"
>
>
> Greetz
> Andreas Schenk
>
>
.
- References:
- Copy a Datbase
- From: S Shulman
- Re: Copy a Datbase
- From: Andreas Schenk
- Copy a Datbase
- Prev by Date: Memory leak with IID_IRowsetChange -> InsertRow
- Next by Date: Re: Newbie Question
- Previous by thread: Re: Copy a Datbase
- Next by thread: Re: Copy a Datbase
- Index(es):
Relevant Pages
|
