LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-28-2009, 01:54 PM   #1
winstone
LQ Newbie
 
Registered: Jun 2009
Posts: 1

Rep: Reputation: 0
Antiques Roadshow Appraiser wants to use Windows data in Linux database-it is hard?


I am a former Antiques Roadshow Appraiser who has a lot of data that I have accumulated over the years in the Alchemy Gold version 6 format which is based on SQL and ODBC
I have been told that Linux maybe a far better OS in which to share data about Gems and Jewelry as well as Consumer protection data with interested parties.
I was a contributor to the 16 CFR 23 "Guidelines for the Jewelry Industry" as well as the United States Stamping Act. I am a consumer advocate, A Texas Paralegal, A Gemological Institute of America Graduate Gemologist, a CIA [certified Insurance Appraiser], member of the Appraisal foundation, and MJSA [manufactor Jewelers and Suppliers Assn]
and Federal Expert Witness for the North Texas Judicial Division of the Fifth Circuit.
My goal is to help set up a free database for consumers with questions about Appraisals, Gems, Jewelry, Spectra, Mineralogy, Gemology, and help locations on the web. Linux that can also use Windows data is important.
I have heard of Linux OS systems that will allow one to run Windows XP as a window in Linux. Sun has such a program. I am wary of free downloads due to the fear of destroying years of data. winstone
 
Old 06-28-2009, 03:03 PM   #2
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,541

Rep: Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060Reputation: 1060
You may want to consider a LAMP (that's Linux-Apache-MySQL-PHP) server; that'll take some conversion effort (and a little web page design) but in the long term a far, far better "platform" for what you're talking about doing. If you can, try to dump your existing data to a flat ASCII file (say, a CSV file with tab separators and no quotes) and you'll able to load your file(s) into MySQL directly. If your software can provide a schema (data base table descriptions), that, too will go a long way toward easing a transition.

If you really want to continue using XP, Sun's VirtualBox (http://www.virtualbox.org) software is a truly good way to go on a Linux platform -- it works, it works fine, and my experience with it has been painless. One advantage of virtual machines is a snapshot capability; you get Windows installed, configured, install all the constant barrage of patches, install your software and data base the take a snapshot of the virtual system; when Windows poops its pants, you can simply restore the snapshot and you're back in business in a few minutes instead of hours from a cold start.

All in all, you're better off biting the bullet and abandoning Windows completely but you can do that in steps if you first go to a Linux platform with virtual machine software installed then gradually migrate from your Windows application to a fully-LAMP platform -- you'll be happier, your clients will be happier and most (if not all) your computer problems will vanish into the mists of time (and you can let the patina accumulate on your Windows machine for a few years then dump it for, oh, maybe $5 to an antique collector...

Best of luck with it.
 
Old 06-28-2009, 03:05 PM   #3
chutsu
Member
 
Registered: Nov 2003
Location: UK
Distribution: Debian Lenny
Posts: 255

Rep: Reputation: 31
To be honest. I have not heard of the program you used for you database, and therefore cannot really comment on if it is possible or not. But I can tell you, it will be a very difficult task, and an experience Linux administrator would be needed to make this possible. I'm not saying you can't do it, but it would be a lot quicker if you had a friend who is very experienced.

If the database is in SQL format, exporting the data and importing it into linux and setting a website for go through the website should not be a problem.

Your last question is not very clear. Are you asking if you can run windows programs on linux? If that was your question then, the simple answer is no, not without installing Wine (A Windows emulator). But running Windows on top of linux is not recommended, becuase at the moment it doesn't run every Microsoft software, most of the time even if you do get the Microsoft software installed on linux it will have glitches and not run smoothly. An alternative will be to Dual boot, meaning having both Linux and Windows on the same computer but are seperate. But then from what you are telling me this is pretty pointless.

Remember Always make multiple backup of your data! Cannot blame some software you don't know how to use for destroying your data!
 
Old 06-28-2009, 06:36 PM   #4
choogendyk
Senior Member
 
Registered: Aug 2007
Location: Massachusetts, USA
Distribution: Solaris 9 & 10, Mac OS X, Ubuntu Server
Posts: 1,194

Rep: Reputation: 105Reputation: 105
OK, so ODBC is essentially a standardized API for databases. Alchemy Gold appears to be a web based document management system that uses the ODBC interface to Microsoft SQL. So, basically, what you have are some data record formats that you have specified to go along with various document types that you stored. What's needed is a linux analog to that whole setup. Unfortunately, the folks who do Alchemy Gold appear to be totally stuck in Windows. So, ... there are probably as many ways to do this as there are linux consultants to tell you how to do it. You'll probably end up dumping your records from Microsoft SQL, and importing them into MySQL. You'll have to understand your record formats and set up corresponding record formats in MySQL. How you get at stuff and allow others to get at it from the web can start getting complicated. We are doing stuff a little like that using Drupal, but that has a learning curve, and requires some effort to set up.

With that much of a definition of the problem, maybe you can give us some more information, and maybe some others can jump in with their own ideas and suggestions.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Processing data from a 'foreign' database with mysql, or tools to pre-process data. linker3000 Linux - Software 1 08-14-2007 09:36 PM
[SOLVED] How do I swap windows on hard 2 to hard drive 1 and linux from 1 to 2 uncle guido Linux - Newbie 5 10-25-2006 12:14 PM
LXer: W Africa Developer Roadshow gets rolling LXer Syndicated Linux News 0 07-17-2006 03:33 PM
Linux/Hard Drive Data. rvijay Linux - Hardware 3 02-09-2005 09:38 AM
Burn Data DVD... Read Data in Linux and Windows SaintStrive Linux - Newbie 3 09-18-2004 06:04 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:20 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration