如何归档数据库中的表并添加到另一个数据库？ [英] How to archive tables in a database and add to another database?

问题描述

如何归档数据库中的表并添加到另一个数据库？假设，一个数据库由10个表组成，并且这些表使用新值非常快速地增长。我想存档特定日期（旧数据）中的值，并从这些表中收集所有这些值，然后创建另一个数据库并将这些存档表放入其中。是否可以使用工具..可以使用C＃创建..

How to archive tables in a database and add to another database? suppose, a database consists of 10 tables, and the tables are growing very fastly with new values. I would like to archive the values from a particula date(old data) and collect all those values from those tables and then create another database and put these archived tables into it. Is that possible with a tool.. which can be created using C#..

推荐答案

是的，应该可以。



阅读以下链接，他们应该提供一个良好的起点。



http://stackoverflow.com/questions/565732/copy-from-one-database-table-to-another-c-尖锐的 [ ^ ]

http://msdn.microsoft .com / zh-CN / library / s4s223c6.aspx [ ^ ]

http://stackoverflow.com/q uestions / 542296 / how-to-duplicate-a-sql-server-2000-table-programatically-using-net-2-0 [ ^ ]



如果你需要在当时添加表格，那么这样的东西可能会有用：

http://stackoverflow.com/questions/10033758/create-sql-table-programmatically [ ^ ]

Yes it should be possible.

Have a read of the following links they should provide a good starting point.

http://stackoverflow.com/questions/565732/copy-from-one-database-table-to-another-c-sharp[^]
http://msdn.microsoft.com/en-us/library/s4s223c6.aspx[^]
http://stackoverflow.com/questions/542296/how-to-duplicate-a-sql-server-2000-table-programatically-using-net-2-0[^]

If you need to add the table at the time then something like this might be of use:
http://stackoverflow.com/questions/10033758/create-sql-table-programmatically[^]

这篇关于如何归档数据库中的表并添加到另一个数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！