I have a legacy Alpha server with a RDB database. This db is replicated in a MySQL db with many bad php scripts that drops all the tables and takes everything from the Alpha. This works very slow and is becoming unmaintainable. Is there a better way to fix this than programming again the scripts? Anything like MySQL Migration Toolkit? ...
I had a problem this week (which thankfully I've solved in a much better way); I needed to keep a couple of fields in a database constant. So, I knocked up a script to place a Trigger on the table, that would set the value back to a preset number when either an insert, or update took place. The database is RDB running on VMS (but i'...
I'm working on a .Net WinForms appliation that is connecting to a legacy RDB database... Some of the fields for dates are stored as integers (imagine 2010-01-04 was the integer 20100104) In the .Net world, I'd much rather work with datetime objects and I've been able to convert the integer into a date, just that it looks so ugly, takes...
Hi, Just wondering, is my program specific 'xyz.rdb' file (generated using makefile) required each time I run my program (xyz.exe) ? Can I embed the .rdb file in the main .exe file generated using VC++ 2008. If the .rdb file is not in path, I usually get the 'Registry Error'. Thanks, Aiwee ...
Hello, I am trying to design an mail system. I have stuttered on the problem that I have no solution yet, but maybe you can point me to some? My problem is I don't really imagine how does the database schema should look like if we are having two different tables for Inbox and Outbox. In example we also must have Users and Messages table...