Sql SERVER数据库更新 [英] Sql SERVER database update

问题描述

我希望将SQL SERVER的数据保存为从实时数据库到本地系统的备份。我每个月都会编写脚本并创建新的db&通过脚本输入新数据库中的所有数据。

我想将数据保存在一个数据库中，而不是多个数据库（我每月创建一次）。这怎么可能我每个月都无法创建新数据库并且现有数据库中的所有数据更新



我尝试过：

I want to kept data of SQL SERVER as a backup from live db to local system. i take script every month and create new db & enter all data in new db through script.
I want to kept data in one db not in multiple (that i create every month). How is this possible that i could not create new db every month and all data update in existing db

What I have tried:

is it possible that database data update in same db every time for example i take script of month January and make a db with name "testing" & when i take script of February and how i enter data in the same db "testing" that previous data present and new data also entered

推荐答案

您可以使用 SELECT INTO 复制表格，请参阅：使用SELECT INTO INSERT INTO新SQL表 [ ^ ]

但请注意，这不会创建约束，索引，默认值等。

You could use SELECT INTO to copy your tables, see: INSERT INTO new SQL table with SELECT INTO[^]
But be warned this does not create constraints, indexes, defaults etc.

这篇关于Sql SERVER数据库更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！