SQLMobile replication to SQL Server 05 64bit
[316 byte] By [OptikDev] at [2007-12-20] 
Assuming you are really asking if you can use merge replication between your SQL Mobile application and the 64-Bit SQL Server, that depends on where your IIS insance is running (IIS is the gateway through which merge and RDA is brokered). The SQL Mobile server tools are not compatible with 64 bit architectures (yet) but that doesn't mean if you had SQL Server 2005 on a 64 bit server and the IIS/Server Tools on a separate 32 bit server that it wouldn't work.
Darren
DarrenShaffer at 2007-9-9 >
Hi,
Same as the need of one of our client, SQL Server 2005 is running on a 64 bit server and IIS is running on a 32 bit server.
It works like a charm knowing we have between 120.000 and 160.000 records for each PDA using merge replication...
The only problem we encountered and solve quite easily was an "invalid parameter" on IIS side, the application pool was resetting connections after only 10 minutes when sometimes we need 15-20 minutes to do the first intialisation (the server is around 4 millions records and PDA are about 150 thousands...).
After this, normal replication are about 10 to 30 seconds, which is quite good.
It works great.
Fabien.
FabienMasson at 2007-9-9 >
SQL Server Hot Topic
- Problem with Union ALl
- Transfer SQL Server Objects Errors
- SSIS error - Data Flow Task LocaleID 0 not installed on this system
- RS 2005: Excessively Long String error when printing
- ODBC Data Source
- Problem connecting to SQL Server 2005 database instance
- Scrpting to genrate surrogate keys
- padding property RS 2005
SQL Server New Topic
- Exporting SQL2000 to Excel via DTS...and password protecting
- Package Name in Custom LogProvider
- Dyanamic Parameters
- Problems with SSRS 2005 - Report Server not working
- Syncing SQL Server 2005 and Outlook
- How to configure sql reporting services and iis through dmz
- Update/Insert Issue with OpenRowset/BulkInsert
- SSIS Configurations XML file not being used
SQL Server
- SQL Server Integration Services
- Data Mining
- SQL Server Reporting Services
- SQL Server Analysis Services
- SQL Server Tools General
- Transact-SQL
- .NET Framework inside SQL Server
- SQL Server Data Access
- SQL Server SMO/DMO
- SQL Server XML
- SQL Server Replication
- SQL Service Broker
- SQL Server Security
- SQL Server Database Engine
- SQL Server Documentation
- SQL Server Setup & Upgrade
- SQL Server Disaster Recovery and Availability
- SQL Server Notification Services
- SQL Server Compact Edition
- Getting started with SQL Server
- Database Mirroring
- SQL Server Express
Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech
Site Classified
- SQL Server
- Windows Forms
- .NET Development
- Visual Basic
- Visual Studio
- Visual Studio Team System
- Visual Studio Orcas
- Visual Studio Express Editions
- Software Development for Windows Vista
- Visual C#
- Visual C++
- Smart Device Development
- SharePoint Products and Technologies
- Feedback for forums and MSDN websites
- Game Technologies: DirectX, XNA, XACT, etc.
- Visual Studio Tools for Office
- Windows Live Developer Forums
- Microsoft ISV Community Center Forums
- Internet Explorer Development
- Visual FoxPro
- Windows Search Technologies
- Audio and Video Development
- Architecture
- Commerce Server
- Gadgets
- Microsoft Robotics Studio
- Community Chat
- BizTalk Server
- Visual J#
- Windows Networking Development
- Silverlight (formerly WPF/E)
- Popfly
- SQL Server Katmai
- Connected Services Framework
- Office Live Development
- Customer Care Framework
- Incubation Technologies
- Software Engineering Discussion
- System Center
- Software Licensing and Protection Services
- Visual Studio Rosario
- Small Business Application Development
- Office
- Windows Server 2008
- JScript
- Storage Platform – Core
- Misc