Re: Renaming a Table in SQLCE
- From: "Laxmi Narsimha Rao Oruganti [MSFT]" <laxminro.online@xxxxxxxxxx>
- Date: Thu, 24 Jul 2008 12:29:45 +0530
Renaming a table is not supported in SQL CE.
Why dont you have a server-client name mapping table where you map server
side table name to client side table. Everytime you download a table with
your own choice and update this map table with the new name. If the
RDA.Pull was unsuccessful, you still have the old table. In the same above
transaction, you could drop the old table so that both old table drop and
table name mapping update happen together or fail.
Thanks,
Laxmi
"M. Rajesh" <mrajesh_mvp@xxxxxxx> wrote in message
news:OTU8ZWJ7IHA.3696@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
I have a situation where I need to implement a custom synchronization
mechanism between SQL CE and SQL Server 2005 using RDA.
One method that I thought of implementing was to rename tables so that the
data could be recovered in case of network errors or failures.
But on researching I found that renaming tables is not a direct feature of
SQL CE like SQL Server 2005 and can be done through VC++ as found in this
link.
But even after this, there are certain scenarios where renaming fails
(long table name, space between table name, index on tables, etc etc).
Is there any way in which renaming of tables can be done directly with the
.NET CF. or any way to implement the RDA in a transaction Scope across
boundaries.
Thanks,
M. Rajesh
.
- References:
- Renaming a Table in SQLCE
- From: M. Rajesh
- Renaming a Table in SQLCE
- Prev by Date: Re: Concurrent database access in SQL 2005 Mobile
- Next by Date: Re: Concurrent database access in SQL 2005 Mobile
- Previous by thread: Renaming a Table in SQLCE
- Next by thread: Re: Renaming a Table in SQLCE
- Index(es):
Relevant Pages
|
