Re: Off topic MS SQL Server

From: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
Date: Wed, 6 Jan 2016 07:51:27 -0700
Message-ID: <CAN6wuX2TO=8zNuq5Eyz+VzRFi58LXbUUbzpxeHktcy=XtYTJsQ_at_mail.gmail.com>

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_at_gmail.com> 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_at_sefas.com> 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_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
>>
>> linkedin: 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> 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 - 15:51:27 CET