Recommended Posts

  Quote
eeek! there is still the issue of getting his software to work with it! unless you want to spend a good weekend hacking the program, your ******.

Do you argue just for the sake of argument? If the software uses ODBC, there should be very little or no problem.

And unless I missed something, I don't beleive shodan (nice name by the way. I'm a system shock fan) stated how the software handled connections. Unless you are the one who programmed the software, you can't really tell.

I get this horrible feeling you are just looking for an excuse, an opening, some occasion to discredit the evn show and his Rational Backed Up Arguments , only for the sake of OS X not being used as a server... but that couldn't be right... right?

So, basically, unless you have knowledge of how his applications are programmed, I doubt your point is very valid. It is worth considering indeed, something to note, but not _the one and only_ truth.

Now, shodan, could you please provide us with more information about the applications that needs to be migrated? That would be alot more helpful. And can they be modified, if necessary?

Oh, and for the sake of information, I onced used MySQL as a storage database for Merak Mail Server through ODBC drivers. Basically, Merak didn't really care what database was on the other end, as long as it could use ODBC. But then again the queries were not very complicated. Insert records, modify records, delete records.

That was done for the purpose of administrating accounts using a web interface I had programmed for a small company. I did the developement on MySQL and they used it on something else, PostgreSQL, I Beleive. In any case my program was using a database abstraction layer I also wrote, so everything was good.

If I were you i'd test. You can most likely use other software platforms to perform the tests, so I'd recommend maybe setting up an extra windows box for the sake of doing things quickly, dump your data to sql and import it back into the other databases.

Edited by mr_da3m0n
  mr_da3m0n said:
Do you argue just for the sake of argument? If the software uses ODBC, there should be very little or no problem.

And unless I missed something, I don't beleive shodan (nice name by the way. I'm a system shock fan) stated how the software handled connections. Unless you are the one who programmed the software, you can't really tell.

I get this horrible feeling you are just looking for an excuse, an opening, some occasion to discredit the evn show and his Rational Backed Up Arguments , only for the sake of OS X not being used as a server... but that couldn't be right... right?

So, basically, unless you have knowledge of how his applications are programmed, I doubt your point is very valid. It is worth considering indeed, something to note, but not _the one and only_ truth.

Now, shodan, could you please provide us with more information about the applications that needs to be migrated? That would be alot more helpful. And can they be modified, if necessary?

Oh, and for the sake of information, I onced used MySQL as a storage database for Merak Mail Server through ODBC drivers. Basically, Merak didn't really care what database was on the other end, as long as it could use ODBC. But then again the queries were not very complicated. Insert records, modify records, delete records.

That was done for the purpose of administrating accounts using a web interface I had programmed for a small company. I did the developement on MySQL and they used it on something else, PostgreSQL, I Beleive. In any case my program was using a database abstraction layer I also wrote, so everything was good.

If I were you i'd test. You can most likely use other software platforms to perform the tests, so I'd recommend maybe setting up an extra windows box for the sake of doing things quickly, dump your data to sql and import it back into the other databases.

Listen, whoever wrote the program that he uses would need to have built in that feature.

  Quote
Listen, whoever wrote the program that he uses would need to have built in that feature.

What feature do you speak of?

You quoted my entire text an said that. I talked about more than one point here, could you be more precise? Because to be honest you are not making much sense.

  mr_da3m0n said:
What feature do you speak of?

You quoted my entire text an said that. I talked about more than one point here, could you be more precise? Because to be honest you are not making much sense.

Well, I can see you're a Linux fanboy.

The feature I referd to was being able to change the type database server. You would need to write that, and most developers wouldnt.

  JadeWolf324 said:
sigh..area91 you just seem to hate macs. is there anything about them you do like?

Ya, there are some things I like about Mac. I like how everything comes with the OS, and I like iLife apps. I also like the looks of some macs. Thats about it.

well arent those all things that windows cant/doesnt have?

windows PC's look bland (for the most part) unless u get urself a nice case.

iLife is only for apple...the apps are what make that so nice.

and Windows comes with...Windows Messenger and...paint.

  JadeWolf324 said:
well arent those all things that windows cant/doesnt have?

windows PC's look bland (for the most part) unless u get urself a nice case.

iLife is only for apple...the apps are what make that so nice.

and Windows comes with...Windows Messenger and...paint.

They cant have them without being sued. Apple will be in that same position (acualty much, much worse, beacuse they do hardware) if they beacome the major computing company.

  Quote

Well, I can see you're a Linux fanboy.

.... I actually yelled "what the f*ck?" really loudly in my basement when I read that.

How the hell does that relates?

  Quote

The feature I referd to was being able to change the type database server. You would need to write that, and most developers wouldnt.

You are just confusing. Isn't that what I said? Most software would use ODBC. Have you written than software? And I assume you know many developpers as well, and you can truely say "Oh yes, they don't." in which case I would promptly keep my trap shut, smile and nod. But you know...

You obviously _are_ just trying to say the opposite of what people who seem to be pro-mac say.

Geez, sometimes I wonder why I even bother...

I have the feeling that once again this thread will be gone to hell before I blink.

OH and also, you seem to ignore the many references to ODBC that has been made... I suggest you google it.

In any case, can we get this back on topic? We were talking about databases on OS X last time I checked

  mr_da3m0n said:
.... I actually yelled "what the f*ck?" really loudly in my basement when I read that.

How the hell does that relates?

You are just confusing. Isn't that what I said? Most software would use ODBC. Have you written than software? And I assume you know many developpers as well, and you can truely say "Oh yes, they don't." in which case I would promptly keep my trap shut, smile and nod. But you know...

You obviously _are_ just trying to say the opposite of what people who seem to be pro-mac say.

Geez, sometimes I wonder why I even bother...

I have the feeling that once again this thread will be gone to hell before I blink.

OH and also, you seem to ignore the many references to ODBC that has been made... I suggest you google it.

In any case, can we get this back on topic? We were talking about databases on OS X last time I checked

I wont fight with you. I know when to walk away.

  area91 said:
Well, I can see you're a Linux fanboy.

The feature I referd to was being able to change the type database server. You would need to write that, and most developers wouldnt.

If the developer was worth his salt, he would have abstracted the business logic from the data completely. There should be little modification to a properly written program. A connection string shouldn't ever be hardcoded into an app, which would be what ties an app to a specific db. That would be something an amatuer would do. A simple configuration file, or registry setting could hold that information. If any developer thinks that's too much work, they should be fired.

@shodan - I must agree, however, that a move from SQL Server to something unknown is probably unwarranted. SQL Server can handle quite a load. You may want to contract a MSSQL DBA to come take a look at your tables, stored procs, etc.

How big has your company become? I've written software that leveraged a single MSSQL box that handled upwards of 2500 clients quite handily. Granted, I didn't do any of the DB design. It probably would have cut performance in half had I done the design. :D

  the evn show said:

  Quote

That's why god invented import and export routines.  Oracle is the king of being a pain in the but to migrate away from (and even that's possible using CSV files and a few hours work).

Of course! :D

I'm at work now, and my idea of testing is to install postgresql on a windows machine, than rebuild one of my database.

I already have all the queries I need to do that, after that I'll simply export and import data from the old database to the new one. I think it should work.

  Quote

Now, shodan, could you please provide us with more information about the applications that needs to be migrated? That would be alot more helpful. And can they be modified, if necessary?

Well basically those are applications wrtten specifically for compiling taxes modules... (here in italy are pretty difficult to compile, and people goes to "special places" to have help). So, they use a new database every year, and does simple add, remove lines into the tables. The only thing i'm pretty sure is that they won't modify the application (if they need to) to suit my needs, because i don't have access to codes, and my company is not the only one who use them... so I just have to try. ;)

  Quote

If I were you i'd test. You can most likely use other software platforms to perform the tests, so I'd recommend maybe setting up an extra windows box for the sake of doing things quickly, dump your data to sql and import it back into the other databases.

Exactly was I was planning to do! :D
  Quote

How big has your company become? I've written software that leveraged a single MSSQL box that handled upwards of 2500 clients quite handily. Granted, I didn't do any of the DB design. It probably would have cut performance in half had I done the design.

Not that big at all!!!! :D

To be honest my idea was just a try... I mean, considering that I have to buy another server in any case, I just thought It would be cool to try and change it to OS X... maybe this way I can one day have Mac clients too.... ;)

Well, off to download PostgreSql for windows.... :woot:

why oh why would you take a chance at messing up a working network and applications just to switch to another OS because you feel it should be? unless the upper level's want it I would never change anything that major... if you mess something up they could have your butt on a frying pan so fast...

  neufuse said:
why oh why would you take a chance at messing up a working network and applications just to switch to another OS because you feel it should be? unless the upper level's want it I would never change anything that major... if you mess something up they could have your butt on a frying pan so fast...

Well maybe because I dare, and only the brave may dare.... ;) I'm kidding.... :D

I think it's because I'd like to evolve... and I think this step should be an evolution... If I had tought, and my boss had thought, the way you suggest I would still have the old Novell network, instead a Windows 2000 Domain, don't you think? ;)

  shodan said:
Well maybe because I dare, and only the brave may dare.... ;) I'm kidding.... :D

I think it's because I'd like to evolve... and I think this step should be an evolution... If I had tought, and my boss had thought, the way you suggest I would still have the old Novell network, instead a Windows 2000 Domain, don't you think? ;)

moving from novell to AD on windows is nothing, but moving propriatory applications that are designed for windows and the backend server (which the applicition may require it to be SQL server, not everyone codes in generic SQL, some depend a lot on the custom features of specific sql servers, ususally is the reason they picked the one they used to begin with is what features it supports) to another OS totaly is relatively very complex, can cause major problems and other things... the cost to even rewrite the software could go through the roof if it was made by a ISV (independent software vendor)... sometimes you have to consider a lot more factors then just what platform it runs on...

  neufuse said:
moving from novell to AD on windows is nothing, but moving propriatory applications that are designed for windows and the backend server (which the applicition may require it to be SQL server, not everyone codes in generic SQL, some depend a lot on the custom features of specific sql servers, ususally is the reason they picked the one they used to begin with is what features it supports) to another OS totaly is relatively very complex, can cause major problems and other things... the cost to even rewrite the software could go through the roof if it was made by a ISV (independent software vendor)... sometimes you have to consider a lot more factors then just what platform it runs on...

Of course, you're very right!

In fact I intend to do it only if it's "painless"... no rewrite of any part of the code, no change of any applications.

For what I've tried so far this is impossible :(.

Too bad even the query I have to create a database use different standars (eg. mySQL wants an instruction terminated by ; MSSQL don't... ).

I think my efforts will be vain.... well, at least I've tried...

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • About that Trump's mobile 🤣🤣🤣  
    • AliExpress faces EU crackdown, makes promises to fight illegal products by Paul Hill The European Commission has taken two significant actions against the Chinese online marketplace AliExpress under the Digital Services Act (DSA) in a bid to enhance user and consumer safety online. The first action was to get AliExpress to commit to several legally binding commitments to address issues related to advertising and recommender systems. The second action was the publication of preliminary findings which found that AliExpress had breached obligations regarding the spread of illegal products. AliExpress can now respond to the Commission but if the broken rules are confirmed then AliExpress can expect to be fined. The Digital Services Act is a new tool that the EU has to regulate large online platforms. It aims to level the business playing field, protect fundamental rights of users, create a safer digital space, and improve transparency from businesses. AliExpress's pledges: More transparency, safer shopping As part of the pledges made by AliExpress, it will do more to monitor and detect illegal products such as medicines, food supplements, and adult material propagated through hidden links and affiliate programs. To help flag illegal items, AliExpress has promised to improve its notice and action mechanism. Other pledges include enhancements to the internal complaint handling system; more transparency for advertising and recommender systems; better traceability of traders on the platform; and improved data access for researchers. By implementing these rules, the European Commission hopes it can make AliExpress safer for registered and non-registered users by limiting the exposure to illegal content. Deep dive into AliExpress's alleged failures With regards to the preliminary findings, the Commission found that AliExpress had underestimated the risks because it had not allocated enough resources to moderation systems for illegal products. It also found that the company had failed to consistently enforce its penalty policy against those publishing illegal content. The Commission also discovered systemic failures in AliExpress’s proactive content moderation systems that allowed malicious traders to continue to operate or start operating on the platform. AliExpress is designated as a Very Large Online Platform (VLOP) which means it has to meet certain standards set out by the EU. The aforementioned violations are against the quality of operation that the EU expects from VLOPs. The company now has the right to defend itself against the EC’s findings, it can examine the documents and reply in writing, but if the findings are confirmed, AliExpress could face fines and be required to submit an action plan.
    • Author/Neowin... The title is incorrect and misleading... By the official blog post, it's not "indefinitely". There's a clear statement that development continues with a few specific target areas, and a new release date TBD and announced later. If it is later announced to be cancelled or delayed indefinitely, that's another story.
    • I hate Microsoft. My parents almost lost all drive content. As senior citizens they are unable to follow constant "improvements" Microsoft is dropping on its users. My mother's laptop is normally unlocked with a PIN. It is unexplicable for non-It person, that there is some cloud mictosoft account, that has a different password than the Pin and user ID is e-mail, but not necessarily normal Gmail addree, and even if the person knows this email address the password is not the password used for this email account. Just too much of twists. Suddenly her laptop ordered entering "decryption key" before booting. It was miracle we managed to guess email address associated with the PC that was used for Microsoft account. She would had lost everything on the drive. Why are they doing this? Privacy may be important for some people, but data loss is much more important for most of the people.
  • Recent Achievements

    • First Post
      xuxlix earned a badge
      First Post
    • First Post
      Tomek Święcicki earned a badge
      First Post
    • One Year In
      carlitin86 earned a badge
      One Year In
    • Reacting Well
      Peterlll06 earned a badge
      Reacting Well
    • Week One Done
      Peterlll06 earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      674
    2. 2
      ATLien_0
      283
    3. 3
      Michael Scrip
      225
    4. 4
      +FloatingFatMan
      192
    5. 5
      Steven P.
      145
  • Tell a friend

    Love Neowin? Tell a friend!