如何在C＃应用程序中添加一些附加功能后更新SQL Server
问题描述：
嗨每一个。
我完成我的项目我的客户现在使用我的软件我在我的应用程序中添加一些新功能所以我的数据库表和存储过程都在增加。
现在Any One告诉我如何在clint计算机中添加新数据库并且Clint Previous Data Remain Save。
请帮帮我谢谢
我正在使用c＃应用程序和sql server数据库
什么我试过了：
我不知道怎么办
Hi Every one.
I Complete my Project And my client use my software now I'm Add some new Features in my application so My database Tables And store procedures are increase.
Now Any One tell me How can i Add new database in clint computer and Clint Previous Data Remain Save.
Please Help me Thanks
I'm using c# Application with sql server database
What I have tried:
I have no idea how can i do this
答
Redgate生产可用于此的产品。有RedGate SQL Compare枚举架构，视图和& SP并将它们与另一个数据库中的相同。为此，您需要同时访问两台PC（我与LogMeIn Hamachi的客户一起使用）。
我相信RedGate还有一个数据库安装项目模板。如果我没记错，你允许向导访问你的数据库并且它有一个代码生成器来在客户端创建数据库。
至于确保客户端数据保持安全......这应该是自动的。你应该始终有一些备份系统。我的大多数客户都有每日备份。如果我想在安装之前获得快照，那么我通常使用SSMS手动处理（再次通过LogMeIn Hamachi连接）。
此外 - 您应该拥有模式的源代码控制快照。
Mike
Redgate makes products that you can use for this. There's RedGate SQL Compare that enumerates the schema, views, & SP and compares them with the same from another database. For this to work you need to have access to both PC's at the same time (I do this with my clients with LogMeIn Hamachi).
I believe RedGate also has a Database Installation project template. If I remember right you allow the wizard to access your database and it has a code generator to create the db on the client side.
As for making sure the data on the client side remains safe... this should be automatic. You should always have some backup system in place at all time. Most of my clients have daily backups. If I want a snapshot just before the installation then I usually handle that manually using SSMS (again through the LogMeIn Hamachi connection).
Also - you should have source control snapshots of your schema.
Mike
https://www.c-sharpcorner.com/article/create-a-sql-server- database-dynamic-in-C-Sharp /
.net - 如何使用C＃为sql server表添加一列？ - 堆栈溢出 [ ^ ]
.net - 如何在C＃中以编程方式备份Sql数据库 - 堆栈溢出 [ ^ ]
如何通过C＃代码恢复SQL Server数据库 - Stack Overflow [ ^ ]
https://www.c-sharpcorner.com/article/create-a-sql-server-database-dynamically-in-C-Sharp/
.net - How to use C# to add a column for a table of sql server? - Stack Overflow[^]
.net - How to backup Sql Database Programmatically in C# - Stack Overflow[^]
How to restore SQL Server database through C# code - Stack Overflow[^]