WAY OT: Need help with Tab Delimited Export formatting

[Shuxclams]

I know its off topic for DC but some of the best minds come here. I have a db I need to export certian fields to a Tab Delimited file format in a specific order and I can't for the life of me get this right..... anyone have experiance with this? Its a MS SQL db export and import fyi.. That also leads to the next question, who has a MS SQL to MySQL conversion utility or script?












SHUX

 

[bunker]

Have you used DTS yet?

Do you have any programming experience? The easiest thing would be to write something like a perl script to connect to the sql db and pull the records you need then insert them into the MySQL db.

 

[Shuxclams]

Originally posted by: bunker
Have you used DTS yet?

Do you have any programming experience? The easiest thing would be to write something like a perl script to connect to the sql db and pull the records you need then insert them into the MySQL db.

Is this what your talking about?









SHUX

 

[Shuxclams]

Also I am not much of a coder, especially with Perl or whatever. I can shell script a little, but code with more evolved languages? HaHaHaHaHa! nope...........














SHUX

 

[bot2600]

Shux, PM me with more detailed information and I will see what I can do

 

[Robor]

bot2600 to the rescue. What a great TeAmmate and forum member!

 

[nagger]

Shux,

There's a conversor available on the MySQL site, here's the link:


B.2 Converters

 

[cakin]

depending on the lengths of some fields, you may be better off performing a comma delimited extraction.

 

[Shuxclams]

Originally posted by: cakin
depending on the lengths of some fields, you may be better off performing a comma delimited extraction.

I wash I could but I have a specific import function in the software package that takes a specifically formatted Tab Delimited file.










SHUX

 

[bunker]

Originally posted by: Shuxclams

Originally posted by: bunker
Have you used DTS yet?

Do you have any programming experience? The easiest thing would be to write something like a perl script to connect to the sql db and pull the records you need then insert them into the MySQL db.

Is this what your talking about?

Sorry for not gettting back sooner shux. Data Transformation Service is a tool in MS SQL server used for importing/exporting data. It would be very easy to go in through enterprise manager and use the DTS wizard to extract the data you needed into a tab-delimited file.

 

[Ken g6]

Originally posted by: Shuxclams

Originally posted by: cakin
depending on the lengths of some fields, you may be better off performing a comma delimited extraction.

I wash I could but I have a specific import function in the software package that takes a specifically formatted Tab Delimited file.










SHUX

There's a couple easy solutions to that. For one, you could import the comma-delimited file to Excel, then save it as tab-delimited. Or alternatively you could get GVim, load the file, type ":%s/, */\t/g" (where \t is a tab), and save it.

 

[bot2600]

It looks like I have the DTS worked out Shux, I sent you a PM with a question about the mappings. The only thing I haven't figured out yet is adding the extra cariage returns in the middle of the lines, but that shouldnt be too hard.

Bot