Post #52,531
9/20/02 4:56:26 PM
9/24/02 11:43:37 AM
|
FWIW
My push for Interbase at my company: | | Sybase Adaptive Server 1.5 | IBM B2 | Oracle 9i | Microsoft SQL Server 2000 | Interbase 6.0 | | Base Cost | $3,995 | $40,000 | $80,000 | $20,000 | $200 | | Cost For 1 User* | $795 | $200 | $600 | | $0 | | | | | | | | | Total Cost | $4,790 | $40,200 | $80,600 | $20,000 | $200 | | | | | | | | | Market Share in year 2000 | 3.2% | 30% | 34% | 15% | ? | | ODBC Driver | X | X | X | X | X | | JDBC Driver | | X | X | | X | | Runs on all popular OS’s | X | X | X | | X | | Multi-dimensional Arrays | | | | | X | | 2-phase Commits | Optional | | | Requires coding | Automatic | | Users | WorldCom | Almost Everyone who doesn’t use MS | Everyone | Almost Everyone | US Army (M1 Abrams Tank), Motorola, Nokia, MCI, Northern Telecom, the Philadelphia Stock Exchange, Bear Stearns, First National Bank of Chicago, the Money Store, NASA, Boeing. |
Many fears are born of stupidity and ignorance -
Which you should be feeding with rumour and generalisation.
BOfH, 2002 "Episode" 10
Edited by tseliot
Sept. 24, 2002, 11:43:37 AM EDT
|
Post #52,650
9/21/02 7:01:00 PM
|
Thank you!
Now for your next trick:
Are there any tools from taking an Access or SQL Server database and migrating it over to Interbase? I am not talking about those flaky things like Erwin that won't even connect to the SQL Server 2000 (but could to a 6.5 or 7.0 server?) or at least the demo didn't, maybe the full version will? But they are not getting my money until I know it can get the damn job done.
When I did a search on Google to find IB and Firebird migration tools, I found results, but the links to those tools didn't work. Que? Others cost between $50 to $200, but the evaluation and demo versions didn't work, QUE? Are there any f*cking reliable database migration tools that f*cking work and don't cost an arm and a leg to buy? The cheapie ones appear to take one look at our Access or SQL Server database and freak out. Even the Microsoft Access 97/2000 Upsizing Wizard barfed on us. My coworker got p*ssed that I was using tools instead of trying to do it by hand. Yeah, I downloaded the damn things at home, burned a CDR because our company bandwidth sucks, and then took 15 minutes to try those tools out instead of taking a break. She took 20 minutes to chew me out for wasting the company time. If this stuff keeps up, I'm giving back the laptop, leaving the database migration product half-done (Hey good luck guys, see ya!) giving them all the source code and documentation to the projects that I was working on, taking all my computer books, my fan, my personal stuff, and then walking out and becoming a f*cking farmer after selling my house. I'd rather grow corn that have people block my path so I cannot get my job done. I'd grow corn, pay off the farm, n if the Government pays me to not grow corn, I will use that money to get a decent laptop (at least 1.2Ghz) and write Open Sourced software to do what my former employers had been doing. Then port it to as many platforms, databases, etc, that I can. Sound like a plan?
[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
|
Post #52,653
9/21/02 7:17:21 PM
|
Oh, yeah. Great plan. Good luck with that.
With all yer bitchin, you might have been done doing it manually by now ;)
Or, you could have spent 5 minutes in Google and come across [link|http://groups.google.com/groups?q=perl+access+dbi+structure+%22create+table%22&hl=en&lr=&ie=UTF-8&selm=nfCu7.20025%24DJ3.1619578%40nlnews00.chello.com&rnum=3|this]. Maybe with a little lovin, it would give you the SQL you need to recreate your DB wherever the hell you want, indexes and all.
--
Chris Altmann
|
Post #52,657
9/21/02 7:37:21 PM
|
Better link for that script...
[link|http://www.cynergi.net/exportsql/exportsql2b.txt|Here]
greg - Grand-Master Artist in IT,
curley95@attbi.com -- [link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!!!]
Your friendly Homeland Security Officer reminds:
Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or
Just continue to type on your keyboard, and we'll just sample your DNA.
|
Post #52,664
9/21/02 8:07:25 PM
|
Thank you guys
now if I can just get the two coworkers bashing MySQL to step down, and show my boss a working version of MySQL and use this tool/script to convert it, I might be able to get it to work.
I think that MySQL might be a better front end database than Access, and it would cut out one more Access project. But like I freaking said a million times by now, it is not within my fucking power to choose the database to run this on. It is the owner and the coworkers that have decided on SQL Server and they hired me because I knew SQL Server. Any ideas on how to convince them?
[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
|
Post #52,869
9/23/02 2:25:41 PM
|
Then do that
It is the owner and the coworkers that have decided on SQL Server and they hired me because I knew SQL Server. Then do what they're paying you to do. Learn new skills on your own time on your own dime. ===
Microsoft offers them the one thing most business people will pay any price for - the ability to say "we had no choice - everyone's doing it that way." -- [link|http://z.iwethey.org/forums/render/content/show?contentid=38978|Andrew Grygus]
|
Post #53,290
9/25/02 8:39:11 PM
|
I am doing that
I am setting up other databases at home. Learning new skills at home. I had an Oracle and SQL Server and MySQL set up at home and Postgres in Cygwin, but I just reformatted the server to start over clean to take work home. I'll put the databases back up, at home, and see what I can do.
I am only developing SQL Server and Access at work. No other database unless they tell me to, but if I learn at home, and they ask me to later, I'll have the skill set. Interbase was downloaded at home, and on my home system, not my server at work or my laptop at work. Besides I try out new software at home anyway.
[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
|
Post #52,700
9/22/02 6:35:46 PM
|
Please remove the returns in your post
To get rid of the big blank section.
Thanks,
Ben
"Career politicians are inherently untrustworthy; if it spends its life buzzing around the outhouse, it\ufffds probably a fly."
- [link|http://www.nationalinterest.org/issues/58/Mead.html|Walter Mead]
|
Post #52,867
9/23/02 2:05:32 PM
|
Wish I could. zIWE parser put them in for me.
Many fears are born of stupidity and ignorance -
Which you should be feeding with rumour and generalisation.
BOfH, 2002 "Episode" 10
|
Post #52,918
9/23/02 8:08:42 PM
|
You _can_
Just go into your nicely formatted html and s/\\n//g.
If there are no line breaks in what you submit, then no line break tags are inserted.
Within pre tags you may want to substitute in the line break instead for the obvious reason.
Cheers,
Ben
"Career politicians are inherently untrustworthy; if it spends its life buzzing around the outhouse, it\ufffds probably a fly."
- [link|http://www.nationalinterest.org/issues/58/Mead.html|Walter Mead]
|
Post #52,881
9/23/02 3:47:25 PM
9/23/02 8:46:37 PM
|
Table re-done, all purty like... only removed breaks
| | Sybase Adaptive Server 1.5 | IBM DB2 | Oracle 9i | Microsoft SQL Server 2000 | Interbase 6.0 | | Base Cost | $3,995 | $40,000 | $80,000 | $20,000 | $200 | | Cost For 1 User* | $795 | $200 | $600 | | $0 | | | | | | | | | Total Cost | $4,790 | $40,200 | $80,600 | $20,000 | $200 | | | | | | | | | Market Share in year 2000 | 3.2% | 30% | 34% | 15% | ? | | ODBC Driver | X | X | X | X | X | | JDBC Driver | | X | X | | X | | Runs on all popular OS’s | X | X | X | | X | | Multi-dimensional Arrays | | | | | X | | 2-phase Commits | Optional | | | Requires coding | Automatic | | Users | WorldCom | Almost Everyone who doesn’t use MS | Everyone | Almost Everyone | US Army (M1 Abrams Tank), Motorola, Nokia, MCI, Northern Telecom, the Philadelphia Stock Exchange, Bear Stearns, First National Bank of Chicago, the Money Store, NASA, Boeing. |
greg - Grand-Master Artist in IT,
curley95@attbi.com -- [link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!!!]
Your friendly Homeland Security Officer reminds:
Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or
Just continue to type on your keyboard, and we'll just sample your DNA.
|
Post #53,077
9/24/02 5:59:00 PM
|
Whoop---Whooop---Whooooop!!!
Coolio... Breaks all gone!!! Excellent!
greg - Grand-Master Artist in IT,
curley95@attbi.com -- [link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!!!]
Your friendly Homeland Security Officer reminds:
Hold Thumbprint to Screen for 5 seconds, we'll take the imprint, or
Just continue to type on your keyboard, and we'll just sample your DNA.
|
Post #53,193
9/25/02 12:31:22 PM
|
Ya NUT!
Didn't realize I was submitting to the Journal of Applied Screedology. :P
Many fears are born of stupidity and ignorance -
Which you should be feeding with rumour and generalisation.
BOfH, 2002 "Episode" 10
|
