No announcements
Found 359418 threads
-
1 VotesBidirectional Sync and Batching with SQL Server 2008 and Change Tracking
I was able to do this by modifying the server side procs to use row_number().Answered | 9 Replies | 13423 Views | Created by Stewart Armbrecht - Wednesday, July 29, 2009 7:29 PM | Last reply by OverloadedOverrides - Friday, September 18, 2009 3:05 PM
-
0 Votes
Use sync framework for synchronization where client already have replica of server data so that intial data changes are not required
Ok, Thanks, do we have maxtimestamp in sql server 2008 internal change tracking system??Answered | 5 Replies | 7934 Views | Created by ptdouglous - Wednesday, April 28, 2010 6:38 PM | Last reply by JuneT - Thursday, April 29, 2010 12:53 PM -
0 Votes
Sql 2008 Express Change Tracking Implementation Help
Of course there is a caveat that the SqlSyncProvider does not have out of the box support for Change tracking feature of SQL Server ...Answered | 4 Replies | 16296 Views | Created by Mark 2011 - Wednesday, April 8, 2009 7:38 AM | Last reply by Mahesh Dudgikar - Saturday, December 5, 2009 4:24 AM -
0 Votes
batching update with SQL Server 2008 change track
Changes for Change Tracking looks correct.Answered | 1 Replies | 11872 Views | Created by frank chen - Wednesday, September 9, 2009 11:03 PM | Last reply by Bob H.L. _ - Friday, September 11, 2009 12:43 AM -
0 Votes
Do I have to use SQL Compact with Sync?
You can use VS2005 to write your own solution, but you may not be able to load the exact sample project in VS2005.Answered | 3 Replies | 6285 Views | Created by Ryan Blogger - Monday, May 17, 2010 3:45 PM | Last reply by Dong Cao - Monday, May 17, 2010 9:29 PM -
0 Votes
Cannot able to do sync db using track change where both side have sql server 2008.
However, if you can consider using triggers, you could use SqlSyncProvider to do the sync between SQL Server databases, which ...Proposed | 6 Replies | 6439 Views | Created by sam.aresh - Wednesday, December 29, 2010 5:05 AM | Last reply by sam.aresh - Wednesday, January 5, 2011 1:16 PM -
0 Votes
Synchronization between 2 SQL 2008 with change tracking
I have 2008 Server to SQL 2008 Express client, using native Change Tracking.Answered | 2 Replies | 9499 Views | Created by mn1aC - Sunday, February 15, 2009 6:49 PM | Last reply by G.Stoynev - Wednesday, February 18, 2009 2:15 PM -
0 Votes
Sync between SQL Server 2008 and SQL Server 2005
which uses the collaboration provider and Sync Fx to provision the tracking tables on both server and clinet.'Answered | 4 Replies | 7507 Views | Created by AjinathWaghmode - Tuesday, May 25, 2010 6:29 AM | Last reply by AjinathWaghmode - Wednesday, May 26, 2010 12:51 PM -
1 Votes
Tool for sync any DB SQL Server 2008 to SQL Server CE
I am not aware of any such tool that will automatically re-create the SQLCE db based on a schema change.Answered | 1 Replies | 15121 Views | Created by Julio Trujillo Leon - Monday, November 30, 2009 4:42 PM | Last reply by Liam Cavanagh - MSFT - Monday, November 30, 2009 5:03 PM -
0 Votes
Collaborative Synchronization - SQL Server Change Tracking
As well, the internal SQL Server Change tracking is more efficient.Answered | 5 Replies | 12782 Views | Created by Garry English - Tuesday, October 27, 2009 10:29 AM | Last reply by Garry English - Wednesday, October 28, 2009 6:30 AM -
2 Votes
synchronize to sql server 2008 databases using wcf
- well thanks for this information but don't you think that this will cause to enlarge the size of the database in all sides (server , clients ) and is there any optimization tips ...Answered | 9 Replies | 9099 Views | Created by Feras mazenTaleb - Wednesday, December 8, 2010 12:03 PM | Last reply by Furqan.Safdar - Saturday, April 28, 2018 7:25 PM -
0 Votes
Data from Sql CE not getting synced to Sql Server DB
I have checked that both server and CE have same schema for all the tables.Answered | 18 Replies | 9356 Views | Created by Sumit J - Wednesday, March 3, 2010 5:46 PM | Last reply by Sumit J - Friday, March 12, 2010 6:49 PM -
0 Votes
Change Tracking | Sync Fx Tracking Table
only the offline providers support SQL Change Tracking.Answered | 1 Replies | 6956 Views | Created by Vishal Mohan - Monday, September 27, 2010 5:53 AM | Last reply by JuneT - Monday, September 27, 2010 3:07 PM -
1 Votes
SqlSyncProvider and SqlServer 2008 change tracking
No, SqlSyncProvider does not work with Sql server 2008 change tracking.Answered | 2 Replies | 7217 Views | Created by ptdouglous - Monday, April 12, 2010 9:28 AM | Last reply by mjayaram - Tuesday, April 13, 2010 2:29 AM -
0 Votes
DB Sync Sql Server With Sql CE
any ways i have another confusion regarding to this Sync technique.Answered | 12 Replies | 8202 Views | Created by Samee Mir - Friday, May 21, 2010 10:04 AM | Last reply by JuneT - Wednesday, June 2, 2010 11:54 AM -
0 Votes
Simple SQL Server 2008 Table changes
here's my take on SQL Change Tracking vs Sync 2.x SQL Change Tracking - Enable tracking ...Answered | 13 Replies | 7824 Views | Created by akakak - Friday, September 24, 2010 8:19 PM | Last reply by JuneT - Friday, October 1, 2010 1:27 AM -
0 Votes
How to Sync after change tracking information is trimmed on the server?
I really worry about one particular catastrophic situation which easily can happen with Sync Framework based application when change tracking is used.Answered | 1 Replies | 6243 Views | Created by Konstantin Erman - Sunday, August 29, 2010 6:20 PM | Last reply by JuneT - Monday, August 30, 2010 1:11 AM -
0 Votes
SqlSyncProvider and SqlServer 2008 change tracking
Hi, In Sync Framework V2.0, SqlSyncProvider still doesn't support SQL Server change tracking.Answered | 1 Replies | 12754 Views | Created by Ricosol - Thursday, October 29, 2009 9:57 PM | Last reply by Dong Cao - Thursday, October 29, 2009 10:30 PM -
0 Votes
SQL Azure to Sql Server sync using Data Sync Services - where to start?
So I found this ...Answered | 2 Replies | 7096 Views | Created by pmcevoy - Wednesday, January 5, 2011 11:09 AM | Last reply by Ann Tang [MSFT] - Thursday, January 6, 2011 12:04 AM -
0 Votes
Transactions and timestamp: Sync Framework for non-SQL Server 2008 databases?
I see that SQL Server 2008 has implemented a clever versioning trick: assign the version at commit time, not at begin trans time.Answered | 3 Replies | 9816 Views | Created by fernandonajera - Tuesday, January 25, 2011 3:41 PM | Last reply by Quicoli - Monday, March 19, 2012 7:37 PM - Items 1 to 20 of 359418 Next ›
No announcements
