sqlite到sql服务器的转换 [英] sqlite to sql sever conversion

问题描述

我将sqlite文件转换为sql server db.之后，我将新列添加到sql server db表中.但是我需要使用已经创建的sqlite列值填充这些列.我怎样才能做到这一点?我的sqlite表具有列versionId和versionName.我转换后的sql db具有相同的列和一个名为CompleteVer的额外列.我需要从现有列值中插入该列值.现在它充满了NULL.我该怎么办..请帮助.

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.

推荐答案

我们不能真正帮助您-我们不知道您要插入什么版本信息.
但是，有两种方法可以做到这一点:

当您添加新列时，请删除"Allow Null"条件，并提供一个默认值.然后，将为所有现有列提供默认值，而不是空值.

如果您可以从其他信息中得出应该使用哪个版本值，请编写一个快速应用程序以为所有空条目生成该值.我们无法真正帮助您做到这一点，因为我们没有关于您将从何处获得信息的信息！

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!

这篇关于sqlite到sql服务器的转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！