I've two SQL Server databases and both of them are on cloud.
- First server is source
- Second server is destination
I only have a non SA access. And I'm using DBForge Studio for managing the database. I'm trying to copy the database from the first server to the second server through
DBForge→Database Sync→Copy Database and then select copy (I'm following this article).
Note: The database already exists in destination with same name, but no tables yet.
I got an error message when trying to copy:
The EXECUTE permission was denied on the object 'xp_fileexist'.....
Then I try to copy & overide but I got the same error message.
So I try to use another way like export & import. I export the database from source server into .sql, but there are only queries for insert, it didn't serve the query for create table schema, and I tried to import into another file like .csv and .xsl but I got the same, it only contain data without schema.
Is there any better way to copy the database without SA access?