Dump of entire database??

[ifrydr]

Hello,

We are in need of an entire dump of the database into a txt or excel file. I would prefer to do a range of all of our bills of materials if that would be possible.... Does anyone know of a way to do this??

Thanks.

 

[dgillz]

Why would you need to do that? What business problem are you attempting to solve?

Excel in particular is a very poor choice as it has a limitation of 65,536 records, subtract one from that if you want column headings.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[ifrydr]

I am being asked by someone at another facility to forward a "dump" of a range of bill of material numbers... I need to know if it is possible? I guess a text file would be the result of choice. They are going to try a manipulate it and use it in their "database" tool, they say they can do it if they can just get a text file.

Thanks.

 

[dgillz]

A partial sump of the bill of material file is a whole lot different from an entire dump of a database isn't it?

I am still in the dark about what they are going to do with this data once they have it. Without knowing this I may be giving you bad advice, so please find out and post back.

Having said all that, you can export the BMPRDSTD table, or for that matter any table, under system manger, processes, the go into the desired module.

This will create a .txt file of the entire table, but you can easily deleted unwanted items in notepad or textpad.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[crystalreporting]

I'm going to guess that they want the text file to import into some other application. If that's the case, you might save a whole lot of work and data manipulation (for them and you) by exporting it to CSV or something similar. You can do this via MSQuery, Crystal Reports, SQL DTS or any number of other methods.

Peter Shirley

http://www.linkcorp.com

 

[MacolaHelp]

Also, having used msquery quite a bit, I can attest to the fact that not all records you expect to get actually come into the excel sheet. I haven't researched which ones or why, but instead have chosen other tools as more reliable such as the database managers or crystal reports.