I have an ASP .NET application that connects to an Oracle or a SQL Server database. An installer has been developed to install a fresh database to an existing SQL Server using sql commands such as "restore database..." which simply restores a ".bak" file which we keep under source control. I'm very new to Oracle and our application has ...
How do you manage your sql server database build/deploy/migrate for visual studio projects? We have a product that includes a reasonable database part (~100 tables, ~500 procs/functions/views), so we need to be able to deploy new databases of the current version as well as upgrade older databases up to the current version. Currently we...
Background: I am using the deployment tools in Visual Studio 2010. I right clicked my project and selected Package/Publish settings. Put all my settings in there ... I am then using "web deploy" to tranfer the files to my remote server running a remote agent service and this is working fine. The transforms i have on my Web.Release.confi...
I'm trying to automate the build process of a database project so that it would automatically be deployed to a database server against which I could run database unit tests. I'm really new to developing databases with VS so this might be obvious, but I can't find a way to make the project be automatically deployed after it is built. I us...
I have a simple database solution in VS team suite '08 (with SP1 and the GDR R2). In the solution I have a server project and a database project. For the purposes of testing, I have only a login in the server project, and only a user in the database project. In the server project, I have defined a command variable $(NTDomain) that is se...
I'm trying to deploy my ASP.NET MVC 2 Website for the first time on a local IIS 7 server, which is configured and running. I've made successful deployments using the Web Deploy option without the databases (so the site isn't fully working yet). Most of the deployment settings are pretty intuitive, however, I have problems with the Packag...
Hello Experts, Can someone please advise me on the below. I have 2 databases, both of then were identical until few years back when we started to add more tables, procedures, views triggers etc to one of the database. Now i have to copy all the changes made in database 1 to database 2. Please, can someone throw some pointers or links...
I'm currently using SQL Server Management Studio. I have a development database, and access to a live database. I just want to able to migrate my development tables to the live server. I'm consulting stack flow first, since I don't want to blow anything up. ...