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?