|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
I've been trying out the remote scripting feature, and found that everything was backed up correctly except for one foreign key.
The missing one was for the (alphabetically) last table in our database - I don't know if that is significant or not. I can't think of anything else that marks the missing foreign key out from any other in the database.
cheers
Bill
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
The issue does seem to relate to it being the last FK for the last table (at least, the last table that has any FKs) in the database. I've just replicated the issue using a toy DB I created just for the purpose, and it always misses the last FK.
cheers
Bill
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Bill, if not too much trouble, could you give us a backup of that toy DB?
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
No problem - I've created a backup. It's 1.5MB. How do you want me to send it to you?
cheers
Bill
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
I've got it. We'll look into it immediately.
|
|
|
|
|
