Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating table structures on distributed Apps
Message
From
14/01/2012 04:02:57
 
 
To
13/01/2012 16:04:27
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
C# 4.0
Miscellaneous
Thread ID:
01532901
Message ID:
01532928
Views:
48
>This C#/SQL Server Express application runs on laptops that are out on delivery trucks all day and return to the office in the evening.
>The laptops have no internet access for a variety of business reasons.
>
>A synchronization program that runs on the laptop places XML information extracted from the laptop tables in a folder on the server in the office. That operation uses an ethernet cat 5 connection.
>Another C# program on the laptop looks in another folder on the server for updates to the processing program and installs them on the laptop.
>For security reasons, the laptop has no access to the SQL Server at the office- just certain folders on the server.
>Later, the server runs a program that uses the XML data left by the laptops to update SQL Server tables.
>
>
>That sounds primitive, but it's working pretty well.
>
>However I can't come up with a good way to bring over changes to SQL table structures, stored procedures, views, indexes, etc on the laptop seamlessly.
>
>Any ideas?

Where does SQL on the laptop come into this ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform