PrepAway - Latest Free Exam Questions & Answers

It writes the data that you specify to a data file, such as an ASCII file.

The SQL Server _____ feature is an efficient means of copying data from a source database to your DB
Instance. It writes the data that you specify to a data file, such as an ASCII file.

PrepAway - Latest Free Exam Questions & Answers

A.
bulk copy

B.
group copy

C.
dual copy

D.
mass copy

7 Comments on “It writes the data that you specify to a data file, such as an ASCII file.

  1. Kree says:

    https://aws.amazon.com/premiumsupport/knowledge-center/rds-import-data/

    SQL Server – RDS SQL Server DB instances cannot be created by restoring data from a .BAK file. For details, see Importing and Exporting SQL Server Data. SQL Server tools that can be used for this process include the Generate and Publish Scripts Wizard, SQL Server Import and Export Wizard, and the Bulk Copy (bcp.exe) command-line tool described at Bulk Copy Operations in SQL Server. The following blog post provides additional information about importing data from SQL Server to an RDS DB instance running the SQL Server database engine: How to Migrate SQL Server Database to Amazon RDS Instance.




    0



    0

Leave a Reply

Your email address will not be published. Required fields are marked *