Both SQL Server CE 2.0 and SQL Server Mobile clients to SQL Server 2000 SP3a - Initial snapshot problem



Dear ALL,

using the following instractions:

1.
Install SQL Server 2000 SP3a replication components (sql2kxxsp3a.msi)
from the following link.

2.
Install .NET framework 2.0 before installing SQL Server 2005 Mobile
Edition Server Tools.

3.
Install the SQL Server 2005 Mobile Edition Server Tools
(Sqlce30setupxx.msi) from the following link.

4.
Execute Connwiz.exe from Start menu: Programs -> Microsoft SQL Server
2005 Mobile Edition -> Configure Web Synchronization Wizard to
configure the virtual directory.

we have complete it but we facing the following problem:

For an initial snapshot of 113375 inserts,

SQL Server CE 2.0 creates an 28,2 MBytes sdf in 10 minutes and
SQL Server Mobile creates an 20,8 Mbytes sdf in 3hours and 40
minutes!!!!!

The time that SQL Server Mobile took is exclusionary.

Please Advise

We think that NOT to upgrade is not a good advice :)

Thanks

.



Relevant Pages

  • Sql server express SP2 Bootstrapper package
    ... Bootstrapper package files as I did with SP1 ... When i try to install SQL server as part of my VS 2005 deployment app I get ... Express Edition requires Internet Explorer version 6.0 with SP1 or later. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQL Server 2008 set up
    ... is available in the most recent update to SQL Server 2008 Books Online. ... you can install SQL Server 2008 Enterprise Edition ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2008 set up
    ... is available in the most recent update to SQL Server 2008 Books Online. ... you can install SQL Server 2008 Enterprise Edition ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.setup)
  • unable to install sql server 2005 enterprise edition on windows vista home premium
    ... I am trying to install sql server 2005 EE on Windows Vista home Basic. ... IIS Feature Requirement (Warning) ... some SQL Server features will not be available ...
    (microsoft.public.sqlserver.setup)
  • Re: installation problems
    ... you cannot install SQL Server Enterprise Edition on Windows XP. ... Windows XP is to remain your OS, you can install the Evaluation, Developer, ... > If client components are sufficient, how do I configure the security as ...
    (microsoft.public.sqlserver.security)