Information générale
Catégorie:
Bases de données
Versions des environnements
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement