SQL Server可以同步实时数据库和创建脚本来生成更新脚本吗?(Can SQL Server synchronise a live database and a create script to make an update script?)
我们目前正在手动更新我们的SQL Server数据库创建和更新脚本,我正在寻找更好的方法。
我以前曾经使用过MySQL Workbench,并且它具有更新数据库创建脚本以匹配实时数据库的功能,并且在此过程中还会生成更新脚本。
SQL Server中是否有类似的功能? 如果是的话,你能提供参考吗?
We are currently updating our SQL Server database create and update scripts by hand, and I'm looking for a better way.
I've worked extensively with MySQL Workbench before, and it has functionality to update a database creation script to match a live database, and in the process also produce an update script.
Is there similar functionality available in SQL Server? If so, can you please provide references to it?
原文:https://stackoverflow.com/questions/20636611
最满意答案
我已经得到了答案..
在我的development.rb文件中添加以下行后,我的问题已解决。
config.reload_classes_only_on_change = false
I have got the answer..
After adding following line in my
config/environments/development.rb
file my issue has been resolved.config.reload_classes_only_on_change = false
相关问答
更多-
每次我进行更改时,Rails Server都需要重新启动?(Rails Server needs restart every time I make changes? why?)[2023-11-01]
我已经得到了答案.. 在我的development.rb文件中添加以下行后,我的问题已解决。 config.reload_classes_only_on_change = false I have got the answer.. After adding following line in my config/environments/development.rb file my issue has been resolved. config.reload_classes_only_on_change ... -
我怎么能让队友从他的机器上重新启动heroku服务器(how can I have a teammate restart heroku server from his machine)[2022-04-04]
他需要Heroku宝石( $ sudo gem install heroku )。 他需要一个SSH密钥和一个使用密钥的Heroku帐户( $ heroku keys:add (pathToKey) )。 他需要将他的账户作为合作伙伴添加到Heroku项目中。 然后就没事了,他可以说$ heroku restart --app (appName) 。 He needs the Heroku gem ($ sudo gem install heroku). He needs a SSH key, and a ... -
即使在重新启动后,我如何保持Passenger Standalone?(How can I keep a Passenger Standalone up even after a restart?)[2021-11-11]
这是我的工作。 使用Upstart(Ubuntu 10.04)启动乘客守护进程 我的环境在ruby 1.9.2和apache上使用rvm,我的rails应用程序通过capistrano部署 # Upstart: /etc/init/service_name.conf description "start passenger stand-alone" author "Me" # Stanzas # # Stanzas control when and how a process ... -
答案是: heroku restart -a app_name # The -a is the same as --app alias hra='heroku restart --app ' 您可以通过将其添加到.bashrc或.bash_aliases文件中来进行永久别名,如以下所述: https ://askubuntu.com/questions/17536/how-do-i-create-a-permanent-bash-alias和 创建永久可执行别名 然后你可以输入hra app_name ...
-
您正在寻找零宕机时间部署 。 Heroku称之为“预启动”。 但是它不能做到免费和爱好动物。 预启动仅适用于使用专业dyno类型(标准和性能)的应用程序。 使用免费或嗜好dynos的应用程序无法访问预引导。 You are looking for zero downtime deployment. Heroku calls it "Preboot". But it can't be done for free and hobby dynos. Preboot is only available to app ...
-
所以答案是FCNMode,但在Windows 7 64位上,注册表位置不同, HKLM/Software/Wow6432Node/Microsoft/ASP.Net 我将FCNMode设置从1更改为2并且没有重新启动加载所有内容就好了。 感谢Brian在ASP.NET论坛上寻求解决方案! http://forums.asp.net/p/1516728/4017980.aspx#4017980 So the answer was with the FCNMode, but on Windows 7 64-bi ...
-
感谢@AllinOne:优雅地重新启动Apache,其中流量不会受到影响,使用 apachectl -k graceful Thanks @AllinOne: graceful restart of apache where traffic wont be impacted, using apachectl -k graceful
-
AFAIK,目前不支持热部署。 I was using the netbeans plugin, and once I moved over to using the Eclipse plugin, I no longer had to restart the server every change.
-
似乎它必须通过重新启动来更新的原因是因为我的CSS覆盖了较少的主要CSS,并且只能在我重新启动服务器时看到,然后我的CSS通过初始化器运行。 否则,如果我只是增加CSS的Less框架,那么它将在刷新时更新。 It seems that the reason it has to update by restarting is because my CSS overrides the main CSS which is Less, and can only be seen when I restart the ...
-
正如此问题所示 ,您键入reload! 在rails控制台中。 As suggested by this question, you type reload! in the rails console.