Hey Brennan, > In terms of complexity, we're looking at no more than 1000 > media items for this first job. (Whether or not there will be > updates is not certain, but quite likely). 1000 items is at > that psychologically testing level where I'm tempted to roll > my own system, but any more than that would start to be a bit > heavy. I don't know much about databases, but I don't see > anything that would not have been attempted before. [...] > Is Filemaker 'just a load of crap, you should use > 4D/Oracle/Access instead'?
It seems huge! I really thing you shouldn't use FileMaker for that :) Try with SQL Server, Oracle or DB2 instead! Then, you can easily connect to an external database using GoldenGate: http://www.GGDBC.com > How much time would it take me (with my kung-fu lingo chops) > to get up to speed with Valentina? GoldenGate doesn't require much more lingo than Valentina though... > We're thinking that they other guys could build some kind of > rough database in Filemaker and then import into Valentina. > Does that sound like duplicated effort? Is it easy to write a > script which takes, say, a dbf file and does the right thing > with Valentina? Or should I make some basic data entry tools > in lingo, so they can do it directly into Director. Personally, I would do it directly in SQL Server (or Oracle/DB2). I strongly suggest you to try with a little amount of data first, to see how it looks like in term of speed. You might want to download GoldenGate and give it a try... Hope this help, Jonathan [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/LUJ/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]) Lingo-L is for learning and helping with programming Lingo. Thanks!]
