Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how to transfer from database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-19 : 08:35:31
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"
   

- Advertisement -