如何将服务器数据库复制到本地主机服务器 [英] How to copy server database to the local host server

问题描述

我想创建一个网站.在服务器端包含数据库.当我访问本地主机上的网站时，那个时候我希望服务器端的数据库复制到本地主机上.更新数据库后，我想替换或更新服务器上的数据库.我是Asp.net的新手，所以如果有人知道这些对我有帮助.

I want to create a website. That contain database in server side. When i acess the website at local host, that time i want the database at server side to copy into local host. After i am updated the database i want to replace or update the database at server. I am new to Asp.net, so if some knows these help me.

推荐答案

那是一个非常糟糕的主意-为什么要这么做? />
考虑一下:数据库和网站具有多用户功能.如果您按照建议进行操作，那么每个尝试登录系统的用户都将获得数据库的本地副本.然后，他们将对其进行修改，并将其写回到服务器.花费时间最长的更改将是最后写入数据库的更改-其他人的更改都可能丢失.

您要达到什么目的，因为我不禁会认为这是错误的方法...

That is a very bad idea - why do you want to do that?

Think about it: Databases and websites are multi-user capable. If you do what you are suggesting, then each user who tries to log in to your system will get a local copy of the database. They will then modify it, and write it back to the server. The one that takes longest to make the changes will be the one who last writes the database - everybody elses'' changes are potentially lost.

What are you trying to achieve, because I can''t help thinking this is very much the wrong way to go...

^ ]
Visual Studio 2010中的SQL Server数据比较工具 [ http://msdn.microsoft.com/en-us/library/aa833435.aspx [ ^ ]
http://msdn.microsoft.com/en-us/library/dd193261.aspx [ ^ ]

SQL Server Schema Comparison Tool in Visual Studio 2010[^]
SQL Server Data Comparison Tool in Visual Studio 2010[^]

http://msdn.microsoft.com/en-us/library/aa833435.aspx[^]
http://msdn.microsoft.com/en-us/library/dd193261.aspx[^]

这篇关于如何将服务器数据库复制到本地主机服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！