Re: RDA or Replication
- From: "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 24 Aug 2005 21:35:48 -0600
You may find one of my MSDN Webcasts valuable in making this decision.
I have a detailed decision flowchart and a pros/cons matrix comparing
merge, rda, and web services. The webcast is available on-demand at:
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032268682&EventCategory=5&culture=en-US&CountryCode=US
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"chamal kalamulla" <chamalkalamulla@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:1AB5C4D6-0A09-418B-9C8E-2CFDC5115385@xxxxxxxxxxxxxxxx
> Dear all
>
> I am developing my first pocket app. i read about RDa and also replication
> on books online. and then i though RDa is the best suitability for my
> application. then i read one of the entreies in this news group. which
> confused me.
> as i under stand to do RDA
>
> 1 i dont need to have have bussiness logic in local sql CE as when doing
> RDA
> the bussiness logic in SQL will be propogated to the local DB. ?
>
> 2.when doing RDA the table which the RDA is performed must not exist in
> the
> SQLCE DB.?
>
> rda.Pull("UserList","Select Title,FirstName from
> UserList",rdaOleDbConnectString,
> RdaTrackOption.TrackingOnWithIndexes,"ErrorTable");
>
> Ie the Userlist table must not exist on the SQL CE DB
>
> 3. If the case is as above where i need to delete each time the userlist
> before doign the RDA. i do have big probelem in hand. some table need to
> remain on the local
>
>
> 4. when doing a RDA push will i have to delete the table on the SQL CE DB?
>
> 5.Can i write the data to the local SQL CE and the slq DB at the same
> time
> disegarding writting failuiers in writing to the SQL.will it create
> duplication issues.? i will cause duplication issues when using RDA Push.
>
> thanks in advance
>
> chamal
>
> P.S I have added the news group question and answer which confused me
> below
>
>
> ********************************************
> well, you can try to execute a query against the table and catch the
> exception that it's not there -or- you can look at the Information Schema
> Views included in SQL CE to determine if the table is there by name.
>
> The TABLES view in INFORMATION_SCHEMA will give you a list
> of tables currently in your database.
>
> Try: SELECT * FROM INFORMATION_SCHEMA.TABLES
> WHERE TABLE_NAME = '{your table name}'
> --
> Darren Shaffer
> ..NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
>
> "Philip Germanos" <PhilipGermanos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:38A4F1FE-BDE5-412B-845F-E5A515893E1B@xxxxxxxxxxxxxxxx
>> Ok, then suppose i have an sqlCe db but i dont know if it contains table
>> X,
>> and i want to pull data into table X, prior to doing the pull how can i
>> test
>> the db to see if table X exists or no?
>>
>> Thank you.
>>
>> "Darren Shaffer" wrote:
>>
>>> the table must not exist locally when you execute your RDA Pull.
>>> it is up to you to delete it prior to doing the Pull.
>>> --
>>> Darren Shaffer
>>> ..NET Compact Framework MVP
>>> Principal Architect
>>> Connected Innovation
>>> www.connectedinnovation.com
>>>
>>> "Philip Germanos" <PhilipGermanos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>>> message news:B64AA99D-AB12-4560-841D-9C7E389CE485@xxxxxxxxxxxxxxxx
>>> > Hello,
>>> >
>>> > When using RDA, if the table selected to receive the data exists
>>> > already,
>>> > does RDA automatically deletes it, or i have to delete it manually?
>>> >
>>> > thank you
>>>
>>>
>>>
>
> 2.
>
.
- References:
- RDA or Replication
- From: chamal kalamulla
- RDA or Replication
- Prev by Date: Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I wonde
- Next by Date: Re: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I w
- Previous by thread: Re: RDA or Replication
- Next by thread: (RDA = OK) + (SqlClient = PlatformNotSupportedException) + I wonde
- Index(es):
Relevant Pages
|
