开发者

Generating update script in Visual Studio 2010 Premium using Schema Compare is dropping tables, rather then altering?

I'm using Visual Studio 2010 Premium's Schema Compare function, to compare two databases.

I have added columns, altered some columns and changed stored procedures. Visual Studio is picking the changes up fine, when I drill down into each table, the Update Action for existing tables is set to 'Update', and the Update Action for the new columns it set to 'Create'.

When I generate the update script it's actually dropping the tables, before creating them again.

How can I generate an update script tha开发者_JS百科t just alters the existing table?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜