如何通过代码将数据库上传到服务器 [英] How to Upload Database to Server through Code

问题描述

我想通过代码在服务器上上传Sqlserver 2005或mysql数据库.有什么办法可以做到的.

因为我正在从事这样一个项目，在该项目中数据库输入是脱机完成的，因此在一天结束时，只需单击一下即可将整个数据库上传到服务器.我不知道将其上传到服务器.

请帮助我.

谢谢

Rohit Sharma

I Want to Upload the Database of Sqlserver 2005 or mysql on the server through code. is there any way to doing this.

Because I am working on such project in which database entry is done offline and later at the end of day the complete database is uploaded to server through one click. I have no idea of doing such upload to server.

Please Help Me.

Thanks

Rohit Sharma

推荐答案

，如果您的sql服务器数据库中有复制功能?


SQL Server复制

if its sql server databases have you looked at replication?


SQL Server replication

为什么不使用SQLite作为数据库，因此您只需上传文件即可.

Why not use SQLite for the database so you can just upload a file.

SQLite的优点是数据库存储在单个文件中.您可以只使用ftp上传它-该站点上其他地方有ftp代码示例.

The advantage of SQLite is that the database is stored in a single file. You can just use ftp to upload it - there are examples of ftp code elsewhere on this site.

这篇关于如何通过代码将数据库上传到服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！