Thanks, but that seems to be only for data, not the whole schema?
John Dunn
Product Consultant
Sefas Innovation Limited.
Tel: + 44 (0) 117 910 0529
www.sefas.com<http://www.sefas.com/>
From: Peter Gram Miracle A/S [mailto:pgr@xxxxxxxxxx]
Sent: 06 January 2016 09:43
To: John Dunn
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Off topic MS SQL Server
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<mailto:peter.gram@xxxxxxxxxx>
linkedin: dk.linkedin.com/in/petergram/<http://dk.linkedin.com/in/petergram/>
OakTable : oaktable.net/members <http://oaktable.net/members>
On 6 January 2016 at 10:10, John Dunn <JDunn@xxxxxxxxx<mailto: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