export tables

Hi,

I want to export some fields (username, password, email) from a table. Can someone advise me how to do this?

Thanks!

 

Take a look at the link in my profile .A lot of DB migration tools are available there

 

insert into database1..tablename (username,passwor,email)
select username, password, email from originaldatabase..tablename

 

is it oracle, mysql, postgresql, etc....db?

 

try this. Suppose your table name is table1

select username,'|',password,'|',email,'|' into outfile '/tmp/x.txt' from table1 order by username

This is in Mysql
Now you have a text file with '|' separated files, all the database packages can import this.

 

For exporting the table values, you can create SSIS package. This is in MS SQL 2005