One of my friends asked me if it is possible to export each table's data to each text file so that
those files can be used in another system for data import?
The point is he wanted to move database from SQL Server to Mysql. But there was not possible to have a
connectivity between the two systems. He generated the script but exporting data was the problem.

I suggested him to run this script that will take all userdefined table's data to each file where filename is the table name itself

declare @tables table(table_name varchar(100))

insert into @tables
select name from sysobjects where xtype ='u'



declare @table_name varchar(1000)

select @table_name=min(table_name)from @tables

while @table_name>''
Begin
        Declare @str varchar(1000)  
        set @str='Exec Master..xp_Cmdshell ''bcp "Select * from '+db_name()+'..'+@table_name+'"
         queryout "C:\data\'+@table_name+'.txt" -c'''  
        Exec(@str)  
		select 
                        @table_name=min(table_name)
                  from 
                        @tables 
                  where 
                        table_name>@table_name

End