Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating table structures on distributed Apps
Message
De
14/01/2012 04:02:57
 
 
À
13/01/2012 16:04:27
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
C# 4.0
Divers
Thread ID:
01532901
Message ID:
01532928
Vues:
50
>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 ?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform