Viewing 15 posts - 36,106 through 36,120 (of 39,903 total)
This is always a little kludge and I haven't seen any great ways to do it. Embarkadero's ER/Studio would do some as would one of FMS Software's products. Not sure...
September 9, 2003 at 10:03 am
The alter statement will not update a date, but it will update the base_schema_ver. You'd have to know the previous versions, but this goes up by 16 with each ALTER.
Steve...
September 9, 2003 at 9:57 am
Frank is correct. There is no benefit to the order of the tables in the statement. This is different from Oracle I believe.
The optimizer considers the request and may reorder...
September 9, 2003 at 9:55 am
Nice. You might want to add this to the scripts section.
Steve Jones
September 9, 2003 at 9:53 am
It's a bad idea in general because SQL is competing with other applications for resources. You tend to separate your database from the applications.
That being said, it's not horrible in...
September 9, 2003 at 9:52 am
It seems to flake sometimes, but not consistently. Is this a consistent or intermittent problem? Is it on all pages?
Steve Jones
September 9, 2003 at 9:47 am
Never been a farmer, suburban boy, but now live on 2 1/2 acres and my wife wants a horse, so I guess I'm about to learn a few things.
Steve Jones
September 8, 2003 at 11:57 am
I guess it depends on the setup of their server, but it's possible this might cause them issues.
However, I'd dispute this and then ask that they upgrade their server...
September 8, 2003 at 11:55 am
Have you scrolled down and to the side? These forums sometimes flip out.
Steve Jones
September 8, 2003 at 11:54 am
Used Embarkadero at a previous job. Liked the ER/Studio, didn't like the Rapid SQL or DBArtison, but this was like 4 years ago.
Visio occassionally, but at this point, I tend...
September 8, 2003 at 10:10 am
Prior to a fulltime DBA, managed IT for a small (< 50 people) company. Prior to that,
software developer
network admin (Novell/DOS/Windows)
Bartender
Waiter
Knucklehead in college
Steve Jones
September 8, 2003 at 10:07 am
I agree that you'd want to check with a Sybase person, but I'd be skeptical of these claims. If there is no access other than inserts, any RDBMS should be...
September 8, 2003 at 10:05 am
Indeed it looked slick and I wish I'd set it up and tested it.
Few issues, basically makes 3 copies (4 total) of the database, so space can be an issue....
September 8, 2003 at 9:54 am
Probably need Client Access or some other driver on the server. We use it from app as well as DTS at J.D. Edwards/Peoplesoft with few issues. Tends to either work...
September 8, 2003 at 9:51 am
Someone else did a test install here. No issues.
Steve Jones
September 8, 2003 at 9:45 am
Viewing 15 posts - 36,106 through 36,120 (of 39,903 total)