Re: renaming a table
- From: "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 15 Aug 2005 19:04:44 -0600
or, rather than renaming tables, create an inbox table each time, RDA pull
to that,
if it succeeds, truncate all rows in your target rable, copy the inbox rows
to the target, and drop the inbox. if RDA pull fails, drop the inbox and
try again.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Rob C" <RobC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4FCF93DD-C131-4DB1-AE10-5D11EB199584@xxxxxxxxxxxxxxxx
>I am using RDA to download a table of staff records from a SQL Server Db to
> my SQL CE database. My problem is that you have to drop the existing
> table
> first. If I do that and the download fails for some reason, i have lost
> the
> table that was there. i could first check for a valid connection before
> dropping the CE table but there is still a chance it could fail for other
> reasons.
>
> i was thinking that i would rename the local CE table and then drop it if
> the download succeeded or name it back to its original name if the
> download
> fails.
>
> I wasn't sure of the best way to do this (couldn't find anything in ALTER
> TABLE).
>
> Also, I was curious how other people might have solved this problem.
>
> Thanks,
>
> -Rob
>
.
- Follow-Ups:
- Re: renaming a table
- From: Rob C
- Re: renaming a table
- References:
- renaming a table
- From: Rob C
- renaming a table
- Prev by Date: import csv to sdf
- Next by Date: Re: import csv to sdf
- Previous by thread: Re: renaming a table
- Next by thread: Re: renaming a table
- Index(es):
Relevant Pages
|
