Chris

Oh god, it's been so long.

I'm using MS SQL Server 2008 Express.  In the Management Console, I can right-click on the database, select Tasks > Import Data, and create a new table based on a CSV file.

How do I do this on the command line?

What I want today is a way to copy data from SQL Server to MySQL.

Production data is kept on the former on server A, and invoicing is kept on the latter on server B.  There's this fifteen-million-step process of exporting the data from SQL Server, using sed to prettify the data, then importing it into MySQL... why not cut all that out?

If I can, of course.

Query!  Is this a sensical thing to do?  I found this...

Originally posted on Dreamwidth.  Number of comments so far:

Awright.  Tomorrow, I will try to create triggers on this SQL Server 2008 db to do something when rows are updated.  (Email me, run a batch file, something.)  Right now, I will bask in my awesomeness, then go home.

Home, to see if I can manage it such that a MediaWiki page can acquire information from a server, elsewhere.  Or if not, to see if I can add a different trigger that sends out information to the Linux server for pickup, or at least goddamn tells me about this new info.

Originally posted on Dreamwidth.  Number of comments so far:

A fuller thing from yesterday's post re PHP/MySQL.

( The steps, laid out. )

So, it's probably that the data's being exported from type bit to type boolean for some daft reason, and MySQL is all like, "I'm taking in tinyint, what's this boolean bullshit?", and setting it to 0, because that's the default value.

It's still bloody annoying that command line works but PHP doesn't, on the same file.

Oh well.  I put cast(the_column as int) as the_column in the query for the package; that should help.

--

[eta] Except that didn't change a goddamn thing.  Motherfuck.  FINE.  LINE BY LINE IT IS, ASSHOLES.

Originally posted on Dreamwidth.  Number of comments so far:

Riddle me this, network/DBA folk.

* We have three servers that hold the production data.  They are on NewNetwork.  The rest of the computers here are on OldNetwork.

* I can use Remote Desktop to get to MainServer, which is on OldNetwork.  It can talk to the three servers.  As in, I can use SQL Server to connect to each of the three servers to access their databases.

(This is really really good, as using VNC to use Remote Desktop to each of the three servers bugs the flying crap outta me.)

* MainServer is using SQL Server 2008 R2.  The server itself is Windows 2008 Server R2.

* The second invoicing system is stored on a Linux box, on OldNetwork.  cat /proc/version gives me: Linux version 2.6.12-2.3.legacy_FC3 (mockbuild@petra.fedoralegacy.org) (gcc version 3.4.4 20050721 (Red Hat 3.4.4-2)) #1 Sun Feb 19 07:48:10 EST 2006

* It is running MySQL 3.23.58, for reasons that utterly frustrate me, but I can't change that at this time.


I want to set something up on the Linux box to get the data from the three data servers into the MySQL db, programmatically.

Can I?

If so, how?

Originally posted on Dreamwidth.