On our oracle databases, we regularly run database export through expdp/impdp utility (wrapped for readability):
$ expdp user/[password] SCHEMAS=<nom_schema> DIRECTORY=expDatapump
DUMPFILE=exp.<schema>.dmp LOGFILE=exp.<schema>.log
Thanks to it we are able to refresh data from a specific schema on test database, for example.
I am wondering if there is such a way to do this in Microsoft SQL Server. I have tested the -> tasks -> "export data" wizard within SSMS, but that was not very helpful (useable only for very small db, PK & FK deleted etc).
Can you perform dumps from your SQL Server databases? On an other hand, is it preferable (if possible) to directly restore a specific SQL Server schema from a .bak file?
Best Answer
There is no way to restore a partial database from a SQL Server backup file. If you are looking to export and import data from various tables in one SQL Server database to another, you'll need to use one of the following methods:
This question and potentially others listed in the "Related" section to the left may offer more help.