I am really trying to understand this tool:


I run BVC5 Import tool as Administrator.



I run this tool in windows vista.



I enter in site url: http://localhost/

username:admin

password:******

note: i use user name and password i use for connecting to bvadmin.



I am moving BV4 data from table dbo.bvc_product to my new BV5 database table dbo.bvc_product.



I hit the import/update button and I select my datasource to import to the database. I use a .csv file from excel.



However it is not working.



here are the columns in BV4:

id

product name

product type id

list price

site price

site cost

meta keywords

meta description

meta title

tax exempt

tax class

non shipping

ship seperately

dropship mode --this is called shipping mode in BV5

shipping weight

shipping length

shipping width

shipping height

status

image file small

image file medium

creation date

minimum qty

parent id

variant display mode

inventory availble qty--not in bv5

inventory low stock notice--not in bv5

inventory status--not in bv5

inventory not availble status--not in bv5

inventory not availble message--not in bv5

short description

long description

manufacturer id

vendor id

gift wrap allowed

Extra ship fee



here are the columns in BV5:


id

bvin--not in bv4

sku--not in bv4

product name

product type id

list price

site price

site cost

meta keywords

meta description

meta title

tax exempt

tax class

non shipping

ship seperately

shipping mode --this is called dropship mode in BV5

shipping weight

shipping length

shipping width

shipping height

status

image file small

image file medium

creation date

minimum qty

parent id

variant display mode

short description

long description

manufacturer id

vendor id

gift wrap allowed

extra ship fee

last updated

keywords--not in bv5

template name--not in bv5

pre content column id--not in bv5

post content column id--not in bv5

Rewrite Url--not in bv5

siteprice overide text--not in bv5

special product type--not in bv5

gift certificate code pattern--not in bv5

pretransform long description--not in bv5

track inventory--not in bv5

small image alternate text--not in bv5

medium image alternate text--not in bv5

out of stock mode--not in bv5

custom properties--not in bv5



is this the only way to migrate one table to another table?



Is there any other way to do this without the migration tool and through the SQL pane,if so what is the syntax I have to use?



I am really confused about all this.



All I want to accomplish is having my dbo.bvc_product table in bv4 move to bv5 dbo.bvc_product table.



Can this be done easily?


Thank you to anyone who can help with this matter, It seems that this may be a migration tool issue or SQL issue.


Daniel