I am working on a SQL Server on which I have three databases:
- User: This is the one where real data resides
- Development: This is used for testing and developement.
From time to time I want to copy the content of the user database into the test and / or development database to make sure that the developement and test environments are as close as possible to the user environment.
I thought I could use the "Copy Database Wizard" for this, but it fails with an error
"Object reference not set to an instance of an object
after I have chosen which hosts to copy from and to (localhost in both cases). I have not been able to find any solutions to this error.
Does anybody have any ideas about what causes this and how to correct the problem (maybe I need to install something or do something with the setup of the server?)
What would be the selected way of doing the transfer if I cannot use the Copy Database Wizard? - This is to be done, I would guess, about once a month.
If it matters, I have full admin access on the database server but not on the underlying windows server.