Re: Off topic MS SQL Server

From: angelo <angelolistas_at_gmail.com>
Date: Wed, 6 Jan 2016 13:53:37 -0200
Message-ID: <CAEX1xDXe=ZHvVMtzNxzoQVof3EF3wQdhHWhMK7UJB6Mk1w7zuw_at_mail.gmail.com>

Well, I think it depends on what kind of working you are trying to do, for choosing bcp or making a backup/restore... with all pros/cons

bcp is good to make import and export bulk, as expdp/imp does

take a look.. https://msdn.microsoft.com/en-us/library/aa337544.aspx

The bcp utility (Bcp.exe) is a command-line tool that uses the Bulk Copy Program (BCP) API. The bcp utility performs the following tasks:

   -

   Bulk exports data from a SQL Server table into a data file.    -

   Bulk exports data from a query.
   -

   Bulk imports data from a data file into a SQL Server table.    -

   Generates format files.

regards,

angelo

On 6 January 2016 at 13:16, Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com> wrote:

> Although BCP is the correct answer, you can also correct the orphaned
> logins to users with sp_change_user_login. I now work for Oracle and rarely
> do MSSQL, but here's your answer,
> http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm
>
> Good luck,
> Kellyn
> On Jan 6, 2016 07:59, "Rich J" <rjoralist3_at_society.servebeer.com> wrote:
>
>> On 2016/01/06 06:55, angelo 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.
>>
>>
>>
>> The backup/restore does work, but it breaks security if *server* logins
>> are mapped to *database* schemas, which they likely are (aka "orphaned
>> users"). And I'm excluding things like replication and encryption that I
>> thankfully have not had to deal with in the SS world.
>>
>> Since I've had to deal with SQueaL Server, I've had good luck finding
>> many answers at places like sqlservercentral.com. Googling for SS
>> answers has often been counterproductive for me due to the morass of
>> "expert" blogs.
>>
>> Or try PostgreSQL instead. ;)
>>
>> GL!
>> Rich
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 06 2016 - 16:53:37 CET