Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
need something to replace msSQL with
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Gentoo Chat
View previous topic :: View next topic  
Author Message
catadoxas
n00b
n00b


Joined: 01 Nov 2006
Posts: 12

PostPosted: Thu Dec 14, 2006 10:47 pm    Post subject: need something to replace msSQL with Reply with quote

well my problem is this

I learned how to work with sql databases in school where we used m$sql servers and I'm fine with those (most of the time)

know Ive reached a point where mySQL just doesn't really cut it anymore... I need the diagrams, role managers bulk etc...
not that Id dislike phpmyadmin but setting up relations could still be easier.

I have a gentoo desktop system with a vm-windowsxp machine on it that runs m$SQL.
the 2 are connected over a private network because I actually don't want windows to access the internet:)

well I didn't find any free unixodbc driver for m$sql (ist that just me?)
So I was asking myself "should I just simply change the server??"

I was actually thinking about oracle10 and tora. my question is this
can I just install It for free? (my system has 2 cores and I remember hearing something about a core-restriction)
and will I get a functional free version that is not 99% crippled?

you'd help me a lot (Im having a serious headache else I'd do some research myself, but I need 2 have a db-server running tommorrow so I ask you guys)

you'd help me a lot:) thx
Back to top
View user's profile Send private message
moocha
Watchman
Watchman


Joined: 21 Oct 2003
Posts: 5722

PostPosted: Thu Dec 14, 2006 10:52 pm    Post subject: Re: need something to replace msSQL with Reply with quote

catadoxas wrote:
well I didn't find any free unixodbc driver for m$sql (ist that just me?)
Are you looking for FreeTDS, provided by dev-db/freetds?
_________________
Military Commissions Act of 2006: http://tinyurl.com/jrcto

"Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety."
-- attributed to Benjamin Franklin
Back to top
View user's profile Send private message
catadoxas
n00b
n00b


Joined: 01 Nov 2006
Posts: 12

PostPosted: Thu Dec 14, 2006 10:56 pm    Post subject: Reply with quote

so it was only me afterall:)
well as I said I'm not really in best shape...
thx a lot for the prompt answer

hm I'm still thinking about installing oracle 10 just 2 know an alternative 2 m$SQL
Back to top
View user's profile Send private message
moocha
Watchman
Watchman


Joined: 21 Oct 2003
Posts: 5722

PostPosted: Thu Dec 14, 2006 11:05 pm    Post subject: Reply with quote

I've done away with the MSSQL and Oracle monstrosities. Granted, I *can* (barely) live without all the enterprisey stuff, but PostgreSQL + contribs have been perfectly adequate for the job (and SQLite for quick and dirty stuff - yes, I abhor MySQL :D).
_________________
Military Commissions Act of 2006: http://tinyurl.com/jrcto

"Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety."
-- attributed to Benjamin Franklin
Back to top
View user's profile Send private message
vibrokatana
Guru
Guru


Joined: 09 Feb 2006
Posts: 328
Location: o0o0oo

PostPosted: Thu Dec 21, 2006 3:04 am    Post subject: Reply with quote

You can install a development version of oracle for personal and educational usage. My school has a dual proc dell server dishing up oracle and htmldb for the students (Running gentoo of course :twisted: ).

I like oracle, but it really likes system resources. Dont be surprised when the installer slaughters your system for several hours.

I have issues with MSSQL cutting out at work and am tempted to lay down a plan to migrate over to MySQL once we migrate our software over to a new version (Mapguide 6.5 right now). The new opensource version seems to run quite well with apache and mysql.

MSSQL works ok, but once you put a heavy load on it the mapguide site becomes unusable and crashes IE, lame.
_________________
My Systems - "I suggest the whole thing be coded in whitespace. Henceforth the code will be obscure and functional at the same time."
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Gentoo Chat 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