Import and Export Data

Question 1

Besides backup and restore, what’s another way that you can move data from one server to another?

Answer 1

You can DETACH and REATTACH it.

EXEC MASTER.DBO.SP_DETACH_DB @DBNAME = N’DATABASENAME’

CREATE DATABASE [DATABASENAME] ON ( FILENAME = N’MDF’),(FILENAME = N’LDF’) FOR ATTACH

Question 2

What are the GUI ways for importing/exporting data?

Answer 2

IMPORT FLAT FILE
IMPORT DATA
EXPORT DATA
COPY DATABASE

Question 3

What is the t-sql syntax for BULK INSERT?

Answer 3

BULK INSERT [TABLENAME]
FROM 'C:\PATH'
WITH (
    FIELDTERMINATOR = ',', --DELIMITER
    ROWTERMINATOR = '\n', --NEW LINE
    FIRSTROW = 2 --WHERE DATA STARTS
)

Question 4

Which SQL Program creates a package for IMPORT/EXPORT DATA?

Answer 4

SSIS (SQL SERVER INTEGRATION SERVICE)