existing (2,752)


Deploying SQL Server Databases from Test to Live

Deploying SQL Server Databases from Test to Live

I wonder how you guys manage deployment of a database between 2 SQL Servers, specifically SQL Server 2005. Now, there is a development and a live one. As this should be part of a buildscript(standar…


php - Mechanisms for tracking DB schema changes

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, argument…


PDF Editing in PHP?

Does anyone know of a good method for editing PDFs in PHP? Preferably open-source/zero-license cost methods.:) I am thinking along the lines of opening a PDF file, replacing text in the PDF and then w…


How do you kill all current connections to a SQL Server 2005 database?

I want to rename a database, but keep getting the error that 'couldn't get exclusive lock' on the database, which implies there is some connection(s) still active. How can I kill all the connections t…


How can I create virtual machines as part of a build process using MSBuild and MS Virtual Server and/or Hyper-V Server Virtualization?

What I would like to do is create a clean virtual machine image as the output of a build of an application. So a new virtual machine would be created(from a template is fine, with the OS installed,…


c# - How do you deal with transport-level errors in SqlConnection?

Every now and then in a high volume.NET application, you might see this exception when you try to execute a query: System.Data.SqlClient.SqlException: A transport-level error has occurred when s…


Refactoring for Testability on an existing system

I've joined a team that works on a product. This product has been around for ~5 years or so, and uses ASP.NET WebForms. Its original architecture has faded over time, and things have become relativel…


SQL Server 2005-Export table programmatically(run a.sql file to rebuild it)

I have a database with a table Customers that have some data I have another database in the office that everything is the same, but my table Customers is empty How can I create a sql file in SQL Serve…


database - How is data compression more effective than indexing for search performance?

For our application, we keep large amounts of data indexed by three integer columns(source, type and time). Loading significant chunks of that data can take some time and we have implemented various…


unit testing - How do you retrofit unit tests into a code base?

Do you have any strategies for retrofitting unit tests onto a code base that currently has no unit tests ?…





add how from create project with example file table database