Replicate Data between SQL Server databases
sergio_nav
Member Posts: 17
Hi!
Now, I have 300 companies in classical .fdb database and I replicate data between laptops and central with software by Rapidionline (www.rapidionline.com)
But I consider change from classical database to SQl Server... And in this new scenario, I will have one central database (in SQL Server) with 300 companies, but I need that one (or more) of my employees can downloaded specific companies to his laptop, work "offline", and latter, upload the information to central database. (This is beacause my employees are consultants and they do accounting in other offices without Internet connection)
The only question is... SQL Server does synchronize data between two SQL Server databases? or I need externel tool to do this?
Thanks in advance
Now, I have 300 companies in classical .fdb database and I replicate data between laptops and central with software by Rapidionline (www.rapidionline.com)
But I consider change from classical database to SQl Server... And in this new scenario, I will have one central database (in SQL Server) with 300 companies, but I need that one (or more) of my employees can downloaded specific companies to his laptop, work "offline", and latter, upload the information to central database. (This is beacause my employees are consultants and they do accounting in other offices without Internet connection)
The only question is... SQL Server does synchronize data between two SQL Server databases? or I need externel tool to do this?
Thanks in advance
Sergio
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions