I have a deluxe windows hosting with plesk which is about to expire. I also have an ultimate windows hosting with plesk which is new. I want to move a mssql db from the deluxe hosting to the ultimate hosting but I can't work out how.
I have tried the copy feature which successfully copies it over to the new ultimate hosting but it copies with it the schema and then in the ultimate it doesn't allow me to change the schema due to permissions.
So the question is, how can I get my db from my deluxe set up to my ultimate set up?