Hi all
I have to migrate a site from an host to another.
Both hosts use mylittleadmin/mylittlebackup.
Backup procedure from first host: ok
Restore procedure from second host: ok

The problem is that in the second host tables have this kind of names:

[firsthostDBname].[table]

So, when i try to exec a query on [table] i get "Invalid object name", otherwise
if I run the query on [firsthostDBname].[table], it works.
This is not what i expect, i want that tables on the second host have this
kind of names:

[secondhostDBname].[table].

Last, i also have the problem of orphan users (in the second db i have the user
of the first db as an orphan).

can you help me, link to guides are welcome

thanks in advance