A
A
Anton Agaltsov2016-08-04 15:27:55
SQL
Anton Agaltsov, 2016-08-04 15:27:55

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

1 answer(s)
D
Dmitry Kovalsky, 2016-08-04
@Archusha

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 question

Ask a Question

731 491 924 answers to any question