Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
MS SQL vs MySQL
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Unsupported Software
View previous topic :: View next topic  
Author Message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Wed Feb 10, 2010 7:36 pm    Post subject: MS SQL vs MySQL Reply with quote

How different is MS SQL from MySQL?
Can MySQL read MS SQL database?

I have a MS SQL database and can read it and damp it as comma delimited file using dbsys.exe, I know the structure of the database but it contain/store some information in blb (blob file); the field are: "Notes" and "Alerts" type: Memo, size: 0
So these fields don't contain any images or pictures.
Is there a way MySQL can read/manipulate these blob files?
_________________
#Thelma
Back to top
View user's profile Send private message
xaviermiller
Administrator
Administrator


Joined: 23 Jul 2004
Posts: 7963
Location: ~Brussels - Belgique

PostPosted: Wed Feb 10, 2010 7:52 pm    Post subject: Reply with quote

Hello,

I don't think MS SQL .mdf files will be recognized by MySQL. But you can check it at http://www.mysql.com/

Can you dump your database as SQL instructions ? This would be more proper.
Or you can install load the databas into MS SQL (SQL Express is for free... under Windows), and use the Data export wizard from SQL Server Management Console, assuming you have the right Windows driver for MySQL (at least ODBC).

After that, you can dump your database with MySQL, in SQL format.
_________________
Kind regards,
Xavier Miller
Back to top
View user's profile Send private message
beandog
Developer
Developer


Joined: 04 May 2003
Posts: 2065
Location: /usa/utah

PostPosted: Wed Feb 10, 2010 7:55 pm    Post subject: Re: MS SQL vs MySQL Reply with quote

Joseph_sys wrote:
How different is MS SQL from MySQL?


Apples and oranges. For one thing, MSSQL uses Transact SQL, while MySQL is (close to) ANSI SQL.

Joseph_sys wrote:
Can MySQL read MS SQL database?


No. Although, you *might* be able to export MSSQL someway to Excel / CSV, and read them in that way.
_________________
If it ain't broke, tweak it. dvds | blurays | blog | wiki
Back to top
View user's profile Send private message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Wed Feb 10, 2010 8:18 pm    Post subject: Re: MS SQL vs MySQL Reply with quote

beandog wrote:
Joseph_sys wrote:
How different is MS SQL from MySQL?


Apples and oranges. For one thing, MSSQL uses Transact SQL, while MySQL is (close to) ANSI SQL.

Joseph_sys wrote:
Can MySQL read MS SQL database?


No. Although, you *might* be able to export MSSQL someway to Excel / CSV, and read them in that way.


Yes, can damp mssql as comma delimited file and import it to openoffice for manipulation the only problem I have, it does not extract the content from the "blb" blob file.
The database extensions are: *.dat *.blb and *.idx; locale is ANSI Standard.
_________________
#Thelma
Back to top
View user's profile Send private message
xaviermiller
Administrator
Administrator


Joined: 23 Jul 2004
Posts: 7963
Location: ~Brussels - Belgique

PostPosted: Wed Feb 10, 2010 8:27 pm    Post subject: Reply with quote

Can't you serialize your blobs ?
What do contain the .blb file ? Is it one file per blob, referenced by some magical info in the CSV ?

Click-click wizards will not work, you will need to serialize the blobs, then reimport them.

If you have a SQL Server licence, you can use Microsoft SQL Server Integration Services, this is a quite powerful ETL system.
_________________
Kind regards,
Xavier Miller
Back to top
View user's profile Send private message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Wed Feb 10, 2010 8:51 pm    Post subject: Reply with quote

XavierMiller wrote:
Can't you serialize your blobs ?
What do contain the .blb file ? Is it one file per blob, referenced by some magical info in the CSV ?

Click-click wizards will not work, you will need to serialize the blobs, then reimport them.

If you have a SQL Server licence, you can use Microsoft SQL Server Integration Services, this is a quite powerful ETL system.


I just called the company that created this program and they are using database from: Elevate Software
http://www.elevatesoft.com/contacts.htm

Will have to give them a call and ask them how to read it, maybe it is not MSSQL at all :-/
The blob file looks like this:
Code:
cat patient.blb
¾Y#dË@=qÒã¼dÐ{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Tahoma;}{\f1\fnil Tahoma;}}
\viewkind4\uc1\pard\lang1033\f0\fs18 test notes update2\f1\par
}
{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Tahoma;}{\f1\fnil Tahoma;}}
\viewkind4\uc1\pard\lang1033\f0\fs18 test allerts update\f1\par
}
{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Tahoma;}{\f1\fnil Tahoma;}}
\viewkind4\uc1\pard\lang1033\f0\fs18 important notes sample\f1\par
}
{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Tahoma;}{\f1\fnil Tahoma;}}
\viewkind4\uc1\pard\lang1033\f0\fs18 test allerts\f1\par

_________________
#Thelma
Back to top
View user's profile Send private message
xaviermiller
Administrator
Administrator


Joined: 23 Jul 2004
Posts: 7963
Location: ~Brussels - Belgique

PostPosted: Wed Feb 10, 2010 9:00 pm    Post subject: Reply with quote

This blob contains a RTF document (with some binary header).

What do you want to do ? I don't understand very well. If the software you cite is for MS SQL Server, it will NOT work with MySQL, because it will use MS SQL drivers, not plain, low-level ODBC.
_________________
Kind regards,
Xavier Miller
Back to top
View user's profile Send private message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Wed Feb 10, 2010 9:25 pm    Post subject: Reply with quote

XavierMiller wrote:
This blob contains a RTF document (with some binary header).

What do you want to do ? I don't understand very well. If the software you cite is for MS SQL Server, it will NOT work with MySQL, because it will use MS SQL drivers, not plain, low-level ODBC.


I'm trying to read and write to this file or at lest update it with my information.
_________________
#Thelma
Back to top
View user's profile Send private message
xaviermiller
Administrator
Administrator


Joined: 23 Jul 2004
Posts: 7963
Location: ~Brussels - Belgique

PostPosted: Thu Feb 11, 2010 10:42 am    Post subject: Reply with quote

Which file ? the MS SQL database ? you can access it from your gentoo box with ODBC drivers to the Windows Server.
_________________
Kind regards,
Xavier Miller
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Unsupported Software All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum