I converted my sqlite file to sql server db. After that I added new columns to the sql server db tables. but I need to populate those column with the values from the already created sqlite column values. How can I do that? My sqlite table have columns versionId and versionName. My converted sql db have the same columns and one extra column named CompleteVer. I need to insert that column value from the exixting column values. now it is filled with NULL. What can I do.. Please help.
We can't really help - we have no idea what Version information you want to insert.
However, there are two ways to do this:
When you add the new column, remove the "Allow Null" condition, and provide a default value. All existing columns will then be given the default, rather than a null value.
If you can work out from other information what Version value you should use, then write a quick app to generate it for all null entries. We can't really help you do that, because we have no information as to where you would get it from!
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)