Upgraded 4.2 to 4.4 get existing record into NEW DB

4 months ago
We have upgraded the nop 4.2 to 4.4

we have added our customize table into migration , after setup  Db created successfully and in upgraded nop 4.40 its working ,

but just worried how can we get the existing record  of table into this new Db ?
there is manually process to get Data , but its so complex and long process


Any other way to get existing record of ( nop 4.20 DB) into the New Db of 4.40
Thanks in advance
4 months ago
So you have an existing table of Data in v4.2 ?
The normal Migration process would update the table and data to v4.4

Anyway, another way is you can Export the Table data using Generate Scripts in SSMS

Right mouse click on Database - Generate Scripts
Select the Table
Then next step in Advanced - select option "Types of Data to script"
Select Data only
Save as Script File
This will create a script which you can use (Maybe modify if needed) to create the data in table v4.4
Run the script on the v4.4 Database
4 months ago
Yidna wrote:
So you have an existing table of Data in v4.2 ?
The normal Migration process would update the table and data to v4.4


Yes we have existing Database , almost around 20 new table and some of modify in existing table
normal migrate can work , but it create a blank table entry for new table


- yes using sql tool and like that work , but we are worried that we need to remove existing record and manage all the things for table match for existing table