Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the methods of exporting TXT text files by SQL SERVER". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "what are the methods of exporting TXT text files by SQL SERVER"?

SQLSERVER export steps:

Select the database to which you want to export data-- > right-click-- Click Task-- > Select Export data-- > (data Source) SQLSERVER Import and Export Wizard-- > default data source SQLSERVER NATIVE CLIENT 10.0 color-- > fill in the server name (or server IP) and database (database to export table data)-- > (destination) flat file destination-- > Select delimiter and file Path name, etc.-- > Select to write a query to specify the data to be transferred-- > fill in the query sql statement-- > Select row and column separators-- > finish

ORACLE import steps:

(WINDOWS version)

1. Create a table under the corresponding user

Create table test0515 (id number (10), name varchar2 (10))

2. Write a control file with a .ctl extension

Load data

Infile "d://test.txt"

Insert into table test0515

Fields terminated by whitespace

(id,name)

3. In CMD

Sqlldr userid=system/123456@testdb control=D:\ test.ctl

Userid represents the user name and login password of the owner of the data table

Control indicates the absolute path where the control file is located (you can also use a relative path)

By default, the import log is under the current CMD path. You can also specify the log save path.

Add log=d:\ test.log

(LINUX version)

You can either script or command directly.

Test.sh

#! / bin/bash

Sqlldr system/123456@testdb control=/tmp/test.ctl log=/tmp/test.log bad=/tmp/bad.log errors=1000 rows=10240000

At this point, I believe that you have a deeper understanding of "what are the methods of exporting TXT text files by SQL SERVER". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.