RE: Off topic MS SQL Server
Date: Wed, 6 Jan 2016 10:09:43 +0000
Message-ID: <EEC3316514CFB24AB2285394E0D405587C928B0A_at_BOU.sefasuk.local>
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_at_miracle.dk]
Sent: 06 January 2016 09:43
To: John Dunn
Cc: oracle-l_at_freelists.org
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_at_miracle.dk<mailto:peter.gram_at_miracle.dk>
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_at_sefas.com<mailto:JDunn_at_sefas.com>> 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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 06 2016 - 11:09:43 CET