Closed. This question does not meet Stack Overflow guidelines . It is not currently accepting answers.
This question does not appear to be about programming within the scope defined in the help center .
Closed 7 days ago.
Improve this question
We are moving an application database between servers and we have used the attach method to attach the database files to the new location.
After re-pointing the application to the new database all operation can be performed successfully except for one, which requires a group of tables modifications. These tables are linked with KFs and has an Index.
We have checked the triggers, FK relations, indexes, it all looks similar to the old database.
Is there a hidden relationship that requires fixing ?
PS: I am a programmer not a DBA.
These are the steps I have performed:
- Copy
.mdfthen paste in the new server - Attach the
.mdfto the new server - Repoint the application to the new IP
- Test the operations, it's all working and can insert/update the new DB
- A group of operations related to logically related tables are not working.
1条答案
按热度按时间omhiaaxx1#
For anyone who’s interested on how we resolved this issue, we have moved the entire master DB into the new server. Until now we did not figure out whether it’s a user permission or it is something that is being used from the master DB, but it solves the problem and all dependencies works smoothly.