Hi
I think you are looking for bcp :
https://msdn.microsoft.com/en-us/library/aa337544.aspx
Med Venlig Hilsen / Best Regards
Peter Gram
*Miracle Expert Services*
Borupvang 2c, 2750 Ballerup, Denmark
Cell: (+45) 53747107
Office Phone: (+45) 44668855
Office Fax: (+45) 44668856
Home : (+45) 38745696
Home : Sæbyholmsvej 18 2500 Valby
Mail: peter.gram@xxxxxxxxxx
linkedin: dk.linkedin.com/in/petergram/
OakTable : oaktable.net/members <http://oaktable.net/members>
On 6 January 2016 at 10:10, John Dunn <JDunn@xxxxxxxxx> wrote:
This is not an Oracle question but I know some of you also manage MS SQL
Server databases and would understand the question!.
I know nothing about MS SQL Server(version we will use is 2012)
Is there an equivalent of datadump in MS SQL server?
Basically I want to know whether there is the ability to do the equivalent
of a system level schema export/import in MS SQL server 2012?
i.e. all schema objects, data, privileges etc
similar to
expdp 'userid="sys/syspw as sysdba"' directory=dump_dir
dumpfile=export.dmp logfile=export.log schemas=MYSCHEMA
--
//www.freelists.org/webpage/oracle-l