My ultimate goal would be to import the new data on a daily basis to both tables.

My problem is the main database is in 6.5 mode. It just wouldn't work.

Please feel free to share what you can!

Everytime I do a restore I have to remove and readd the permissions to the restored tables. It's a pain. How do you deal with permissions after a...