BCP items the same as datapump, but it will accomplish the objective and is
very powerful.
Kellyn
On Jan 6, 2016 05:55, "angelo" <angelolistas@xxxxxxxxx> wrote:
Good morning John,
Try to make a backup/ restore of the database, all of whole schema from
the database you had targeted for backup will be included.
So, be aware that the biggest difference between Oracle and sql server is:
=> Oracle environment: one database instance and n-schemas into this
database. Export and Import will be suitable
=> Sql server: one instance and n-databases you can create.
For example, me. I used to create databases doing a restore for
development or test purposes.
Or, by using sql server management studio ( aka SSMS) you can export or
import tables from one to another database on the same/other server.
bcp is not the same of expdp
* sorry for my bad english
regards,
angelo
On 6 January 2016 at 08:09, John Dunn <JDunn@xxxxxxxxx> wrote:
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
*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
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