![]() ![]() What this means? Means that even a simple requirement as foreign keys consistency will not be available. As it has some nice feats, has equally bad points.įor example, MySQL is most know for being a super duper fast RDBMS. Speculations apart, I have some points to bring about MySQL. Maybe they sell a commercial version, but they already did it while as under MySQL AB. It is still remain being developed as Open Source. I would agree much about PG with StarShip3000 said.Ībout MySQL, I think it's too much dooming speech about Orcle owning it. Older post that adds to this and is even more true today. Don't just default to SQL Server because your a. You can't go wrong going with PostgreSQL if you have the chance to test it and validate it in your environment use this time to compare. Microsoft knows how to sell and it's part of the model that you will out grow express. My guess is at some point you will out grow the express edition and have to start buying a payed version. NET shop)? Yes it's worth considering but depends if cost matters to you. Is it even worth considering this alternative (especially considering the fact that we are a. But I would say all of them can perform well if used correctly. So you aren't comparing apples to oranges here. Performance comparisons of these 3 databases? Well SQL express can't hold more than 4 to 10GB forget how much 2008 express can do. Memory footprint? Can be small or large depending on how you adjust memory settings. For example you can compile with different page size if you wanted to. ![]() Installation ease? Easy with more options than SQL Server. ![]() Support of a similar tool like Management Studio? PG yes pgadmin or a few other third party vendors. NET object support? Not sure what this is. On a Linux box it's really fast if you pre-compile it or use a package install, I would say less than 10 minutes. But if install time is your driving reason to leave SQL Express PostgreSQL does install pretty fast on Windows or Linux, how fast I don't know because I don't care if it takes 1 minute or 10 minutes on my systems. ![]() BSD license is free to use and change the source. Not worth having to pay to use a second rate open source database in my opinion when you can use PostgreSQL for free and without fear. MySQL - Stay away from it, things have gotten ugly and will get uglier now that Oracle owns it. To me that's where the advantages really stop for SQL Server and it's more of a even playing field with other database systems. Of course it ties in really nicely with the native libraries and development tools from Microsoft. NET shop that you have to use a Microsoft SQL Server Product, although Microsoft loves it if you do. SELECT COUNT(*) FROM "tablename" after the query I got an error message:įound my mistake, name of the initluck24dg4odbc.ora was wrong, should be 'm a person who doesn't believe just because you are a. created initluck24dg4odbc.ora file in the hs/admin folder of the gateway server:ĬREATE DATABASE LINK LUCK24 CONNECT TO "user" IDENTIFIED BY "passwod" USING 'luck24' restarted the lisenter, made a ping from the database server to the gateway: tnsping luck24, was succesful (ADDRESS=(PROTOCOL=tcp)(HOST= host_ip_from_gateway_server)(PORT=1521)) edit tnsnames on the oracle database server Server 2008 64 bit: I installed the gateway software on the 2008 32 bit server, also installed an 32 bit ODBC mysql connection on the same machine, name of the ODBC connection is "LUCK24", test was succesful. Database Server: Windows 2008 Server 64 bit, Database version 11.1.0.7.0 Gateway Server: Windows 2008 Server 32 bit, Gateway version 11.1.0.7.0 Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben (SQL State: IM002 SQL Code: 0) ORA-28500: connection from ORACLE to a non-Oracle system returned this message: tried to make a simple select statement: SELECT COUNT(*) FROM created a database link: CREATE DATABASE LINK LUCK24 CONNECT TO "user" IDENTIFIED BY "password" USING 'LUCK24' new entry in my tnsnames.ora: LUCK = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = GOGAPC01001)(PORT = 1521)) (CONNECT_DATA = (SID = LUCK)) (HS = OK)) new entry in the listener.ora: (SID_DESC= (SID_NAME = LUCK) (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server) (PROGRAM = hsodbc)) created a new file initLuck.ora in hs/admin folder, prameters are: HS_FDS_CONNECT_INFO = LUCK HS_FDS_TRACE_LEVEL = OFF installed 32bit DNS ODBC driver for the mysql database, tested it and it was successful, Name is LUCK Some infos about my system and steps I did so far: My goal is to access a mysql server from oracle. I made a post about it already in the general section, but here is the better place for my question. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |