I have a table in an access table which contains Product entries, one of the columns has a jpg image stored as an OLE Object. I am trying to import this table to MySQL but nothing seems to work. I have tried the MySQL migration tool but that has a known issue with Access and OLE Objects. (The issue being it doesnt work and leaves the...
What is the best way to copy a directory (with sub-dirs and files) from one remote Linux server to another remote Linux server? I have connected to both using SSH client (like Putty). I have root access to both. ...
Can anyone point me to a tutorial on the best way to open a connection from client to server, read in a binary file and send its contents reliably across the network connection? Even better, is there an open source library that already does this that I could refer to? Thanks! ...
Which is generally considered "best practice" when wanting to securely transmit flat files over the wire? Asymmetric encryption seems to be a pain in that you have to manage keysets at endpoints and make sure that the same algorithm is used by all clients, where as SFTP seems to be a pain because of NAT issues with encrypting the contro...
Does anyone know how to transfer the users of a vBulletin forum to a new installation of IceBB? ...
I am looking for a good way to transfer non-trivial (10G > x >10MB) amounts of data from one machine to another, potentially over multiple sessions. I have looked briefly at *ftp (sftp, tftp, ftp) http torrents (out because I will not have a seed network in general) rsync (not sure if I can really adapt this to what I need) Are ther...
As usual, some background information first: Database A (Access database) - Holds a table that has information I need from only two columns. The information from these two columns is needed for an application that will be used by people that cannot access database A. Database B (Access database) - Holds a table that contains only two c...
If I setup a CRON that runs a PHP script that in turn moves a file from one server to another, what would be the best way? Assume I have been given the proper username/password , and the protocol (like SFTP) is only prohibited if the language can't support it. I'm really open to options here -- these are XML files that hold order export ...
I'm developing an application with a team in .Net (C++) and provide a COM interface to interact with python and other languages. What we've found is that pushing data through COM turns out to be pretty slow. I've considered several alternatives: dumping data to a file and sending the file path through com Shared Memory via mmap? Stre...
Here's my problem at a high level: We have two business applications. App1 inputs and stores a large set of data. We need something that will transfer data from App1 to App2 whenever any relevent data in App1 has changed. Essentially we want the data in App2 to be synchronized from App1, except that App2 contains a subset of the data...
I've currently got a tool which allows me to configure a database connection (using JDBC) and specify a set of queries to run against the database. This is scheduled to run at a specific time of day (using cron or windows scheduler currently). The tool then exports the results to a file (xml) and sends this file to my server via HTTPS. T...
Hi, we have this scenario: A server which contains needed data and client component which these data wants. On the server are stored 2 types of data: - some information - just a couple of strings basically - binary data We have a problem with getting binary data. Both sides are written in Java 5 so we have couple of ways.... Web Se...
In C/C++, if a multi-byte wide character (wchar_t) value is transmitted from a big-endian system to a little-endian system (or vice-versa), will it come out the same value on the other side? Or will the bytes need to be swapped? ...
A valid JSON Syntax is something of the kind: { "username" : "admin", "password" : "123" } But what if I want to transmit an array of 'users' (given the example), instead of a single 'user' ? Is the code below Valid JSON, according to the specifications? [{ "username" : "admin", "password" : "123" }, { "username" : "bbvb", "password...
I have an existing SQL Server 2005 database that runs our accounting/inventory application. We are looking at using a new on-line ordering framework - which has it's own database. If we use this new framework, we will need to transfer the on-line ordering data (inventory, prices, orders, customers) - almost realtime - to and from, our ...
I have a new database, similar to the old one but with more columns and tables. So the data on the old table is still useable and needs transferring. The old database is on a different server to the new one. I want to transfer the data from one database to the other. I have navicat, but it seems to take forever using the host to host d...
I'm afraid that I already know the answer to my question, but I'll ask it anyway: When there are two MySQL DB servers, can I access data that is stored on the other server? In other words: Can I somehow do this: INSERT INTO table (x, y, z) SELECT x, y, x+y FROM [otherserver].[database].[table] Is the answer really as short...
I often have to transfer large files >50GBs sometimes >100GBs between drives both internal and external during backups of our networks email servers. What is the best method of transferring these files? Command Line such as XCOPY? Possibly something robust enough to continue the transfer if interrupted due to time limits or network is...
Jeff Atwood talked about doing an ISP-to-ISP file transfer: http://friendfeed.com/e/63fb9e72-6cd5-a8ac-88dc-02ce720033f9/wow-just-did-an-isp-to-isp-file-transfer-650mb-in/ What is this? I tried Googling for it, but couldn't find anything. We have a need to transfer large amounts of data between two data centers, and this sounds inter...
I've just been tasked by my boss to implement in a week a way for a remote shipper to be able to access our system and obtain orders they need to process, and print a packing label from UPS Worldship. This remote office isn't part of our business; they would be accessing our systems via a web front end (what amounts to an extranet) - on...