How to transfer data

[tguclu79]

Tugrul Guclu writes "Hi ,

We have a single board computer with XP Pro , SQL Server 2000 , .Net Framework installed. But there is no monitor , Mouse or keyboard. We record incoming data from serial port to sql server by stored procedures.

Since there is no monitor-keyboard-mouse all we can communicate with PC is USB port. When user plugs a USB device , appliation in C# automatically recognizes USB device and a transforms collected data from sql server to an xml file by WriteToXml method. Here are my questions

1-Is there another way of deploying it in USB by SQL Server tools? Like using a views/defining a job or something ? Because using XML for this job slowes down the PC and sometimes it takes very large file sizes when carried by XML( > 500 MB)

2-What is the minimum configuration of SQL Server that occupies less disk space and RAM ? Is there a client tool or something ?

Thanks in advance

 

[Walid]

That is a weird configuration but in any event, I guess SQL-Server has nothing to do with your problem. I imagine that the C# application, with some help from ADO.NET, retrieve the data from SQL-Server, process it and then write it to a file and transfer it to communication port. If the data format need to be changed, the C# developers need to write the necessary code to transform the data to a less space-demanding format like flat file or so. Most likely that this data was intended to be read by another application which expect to find it in a certain format (XML in that case) , you will also need to plan for that. Some one can write XSLT code to transfer the flat file back to the XML format.

Another approach is to use any commercial file compressing DLL to reduce your original XML file size before sending it to the USB port. Many of these libraries are available for very good price. You don’t need a library targeting C# or .NET platform. If it is COM based library, your developers still can use it from C#. This approach is the one I would do if I were in your position because it is the lower risk one (fewer changes in code, etc)

Good luck


Walid Magd (MCP)

The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity.
-Grady Booch