how to move the content in form "SKU" to "Model" in each products all at once

[denagpam]

Hi

I have a problem that I have fill the wrong form in which the contents in form "SKU" should be in the form "Model"

so how to move them onto the latter form ?

[llegrand]

Make a backup of your database PRIOR to working in it.

In your database,  the two fields are located in the table called Products.   
Export that table to a CSV spreadsheet move your values from SKU column to the Model Column.   
Save as CVS.
Import your table back.

[epimadman]

Is there a way to issue an SQL command to copy all from the SKU table to the MODEL table?  For someone with 35000 products, exporting products won't work even with high memory allocations.

Ideally there would be an easier way to do this as the sku is required to order from the distributor and it doesn't show up in print invoice.  Any suggestions?