Hi,
Never thought of the MS Access solution, but it sounds interesting and I am
intrigued. If the data volume is not that big, it could be a quick and dirty
way of doing it.
Sql Server 2005 and Sql Server 2008 Integration Service (SSIS) can do this,
but as far as usability is concerned, it is a s
I have been searching and searching for a clear and logical explanation
of JOINs and have found nothing that can be reasonably understood.
Perhaps I am dense or from another planet, but nothing seems to fall
into place.
I need to display all the books (with their respective authors and
publishers)
Hi,
Using ODBC Drivers and MS Access you can do the job.
This is a quick list of steps(if you need more in depth just ask):
Download ODBC drivers for MySQL from www.mysql.com
Install the ODBC drivers
Create a System Data Source Name that point to the MySQL database (Control
Panel->Administration
2009/2/21 Chris Rehm
> I want to write some programs to work with data from eveonline.com but my
> installed database is MySQL and the data format they provide is a backup of
> MSSQL. They recommend installing SQL Server 2005 Express and I've downloaded
> that and am willing to install it, I just
There are products out there that convert from ms sql to MySql.
Though I would test them before trusting them
--Original Message--
From: Chris Rehm
To: mysql@lists.mysql.com
Subject: moving data to MySQL
Sent: Feb 21, 2009 10:47
I want to write some programs to work with data from eveon
I want to write some programs to work with data from eveonline.com but my
installed database is MySQL and the data format they provide is a backup of
MSSQL. They recommend installing SQL Server 2005 Express and I've downloaded
that and am willing to install it, I just want to know if there is a
Hi Baron!
I am going to try your solution on preprod on monday.
In the meantime, using your great slow-query-log analyzer, the strategy
I thought of was similar to yours,
but using only one select that only put a READ lock on the records
because, while the table is very 'selected' also at nigh
