Re: Off topic MS SQL Server

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