>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only