Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We are trying to deploy a .Net Compact Framework app that uses a local SQL Server Compact database that is replicated to a SQL Server 2005 SP3 database to our test environment.

In our Development environment using ActiveSync we can initialise the 40mb database simply and easily. However, in our testing environment the server is only sending 1-2K per second and our initialisation times out.

We use Avalanche to deploy in the testing environment and place the Motorolla MC75 device into a cradle to start the syncronisation.

Does anyone have any ideas?

share|improve this question
add comment

2 Answers

Do you have Windows 2003 Service pack 2 ? It enable by default network offload, which cause issue if the network driver is too old. Since, another hotfix disable this network offload by default.

Some problems occur after installing Windows Server 2003 SP2

==> it specify SQL network problem related to this network offload.

Also check for:

  • Antivirus / firewall
  • Network problem (duplex mismatch...)
share|improve this answer
add comment
up vote 0 down vote accepted

The problem turned out to be that we had defined our own RowGUIDs on the replicated tables which had a default constraint of GetID(). By changing this to be GetNextSequentialID() our performance suddenly dropped from 10 hours+ to around 20 minutes.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.