Answer the question
In order to leave comments, you need to log in
How to transfer MS SQL database from one server to another?
There is a server with MSSQL standart 2008 - but there is no access to this server (not on Windows, not sa), there is only a login and password for working with the database (I easily connect using it via Management Studio).
There is a new server with MSSQL standart 2012 - you need to transfer the database from the first server to this server.
When you run the "copy database" procedure, it gives the error "SSIS Error: An OLE DB error has occurred. Error code: 0x80040E09 – SELECT Permission was denied…" - judging by Google, the user available to me does not have rights to this, or am I mistaken?
I tried to do Data Export, but in this case, in the created database, all tables do not have keys, but all data is transferred correctly.
How to be?
Answer the question
In order to leave comments, you need to log in
Option 1: Kick the database server administrator. Or let them give rights or let them migrate.
Option 2 (optimistic, but I know that it won't work): If the database structure is saved as SQL scripts (including creating keys and other things) - roll up the structure, and then migrate the data.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question