Latest developer linksBookmark and Share
 
HomeThis WeekTop MonthTop AlltimeSearchRegisterFAQ
  
 
Submit Your Link
Please login to submit your Link
 

SQL Server -- compare and update schema of live database from test database

Posted: Jan/22/2011   By: nikhil   Points:15   Category: .NET  - ASP.Net    Views:75   Vote Up (0)   Vote Down (0)    

I have two databses on a SQL Server -- one for development (call it "TestData"), and one for production (call it "LiveData"). I make changes to TestData -- typically adding tables or adding new fields to existing tables (rarely dropping anything) and creating or modifying Stored Procedures. At some point, I would like to update the LiveData tables, stored procedures, etc. with the changes made to TestData. I only want this to affect the schema, not the actual data. What is the best way to do this? I am new to SQL Server, so the more detailed the explanation, the better.

edit: I know there are third-party programs out there, but I'm looking into ways to do this without a separate software, just using scripts, etc.

View Complete Post


Comments:
Be the first to comment this post.
 
Post Comment
Please login to post your comment
More Related Resources

Caputurig Back Button Event & Force The Page To Load From Server:

  
I think in many time developer need this event, which is not provided by any browser and it is not captured by any javascript event.In this Article you see how you capture this event and how you force the browser to load the page from server.

PleaseWaitButton ASP.NET Server Control

  
An approach to displaying a "please wait" message/animated gif following a button click using encapsulated client-side JavaScript.

It is often useful upon a form submission in a web application to display a "please wait" message, or animated .gif image, particularly if the submission process lasts a few seconds or more. I recently developed a survey submission application in which internal users upload excel spreadsheets through a web page. The application inserts the uploaded data from the spreadsheets into a database. The upload/insert process may only take a few seconds, but even a few seconds on the web is a noticeable wait. When testing, some users clicked the upload button repeatedly; it was useful to provide a visual clue that the upload was underway. For that matter, it was useful to hide the upload button altogether, preventing multiple clicks. The control presented here, a subclass of the Button control, demonstrates how client-side JavaScript code encapsulated in an ASP.NET server control can provide such functionality conveniently.

How to format and update GridView and DataGrid rows using JQuery

  
The behavior described in this question is as expected. When you set text of a cell in grid, it directly affects HTML that is going to be rendered. When you set text value of a cell, it means that you are setting innerText of the cell. The column that GridView creates for command fields (Edit, Delete and Select) are a (anchor) or button elements. So you can see what will happen if you set text value in that cell. It will wipe out those link or button controls and replace them with simple text string.

IIS Issues - Unable to start debugging on the web server. The underlying connection was closed. The connection was closed unexpectedly.

  

All of the sudden I'm getting the following error on my local web server (Win7 64bit, IIS 7.5).  I've uninstalled & reinstalled IIS locally and it didn't fix it.  IIS is set to start up automatically and I can see that the service has been successfully started.  Upon a fresh reboot if I go into IIS and click on start website I get the following error:
"The process cannot access the file because it is being used by another process.  (Exception from HRESULT:  0x80070020"
If I try to start debugging on my local website project I get the following error:
"Unable to start debugging on the web server.  The underlying connection was closed.  The connection was closed unexpectedly."
Any ideas on what I can try?  I've been doing research on the issue and Microsoft suggest making sure no other service is listening on the same ports.  I've verified that this isn't the issue.

All of the sudden I'm getting the following error on my local web server (Win7 64bit, IIS 7.5).  I've uninstalled & reinstalled IIS locally and it didn't fix it.  IIS is set to start up automatically and I can see that the service has been successfully started.  Upon a fresh reboot if I go into IIS and click on start website I get the following error:

"The process cannot access the file because it is being used by another process.  (Exception from HRESULT:  0x80070020"

If I try to start debugging on my local website project I get the following error:

"Unable to start debugging on the web server.  The underlying connection was closed.  The connection was closed unexpectedly."

Any ideas on what I can try?  I've been doing research on the issue and Microsoft suggest making sure no other service is listening on the same ports.  I've verified that this isn't the issue.


IIS Issues - Unable to start debugging on the web server. The underlying connection was closed. The connection was closed unexpectedly.

  

All of the sudden I'm getting the following error on my local web server (Win7 64bit, IIS 7.5).  I've uninstalled & reinstalled IIS locally and it didn't fix it.  IIS is set to start up automatically and I can see that the service has been successfully started.  Upon a fresh reboot if I go into IIS and click on start website I get the following error:
"The process cannot access the file because it is being used by another process.  (Exception from HRESULT:  0x80070020"
If I try to start debugging on my local website project I get the following error:
"Unable to start debugging on the web server.  The underlying connection was closed.  The connection was closed unexpectedly."
Any ideas on what I can try?  I've been doing research on the issue and Microsoft suggest making sure no other service is listening on the same ports.  I've verified that this isn't the issue.

All of the sudden I'm getting the following error on my local web server (Win7 64bit, IIS 7.5).  I've uninstalled & reinstalled IIS locally and it didn't fix it.  IIS is set to start up automatically and I can see that the service has been successfully started.  Upon a fresh reboot if I go into IIS and click on start website I get the following error:

"The process cannot access the file because it is being used by another process.  (Exception from HRESULT:  0x80070020"

If I try to start debugging on my local website project I get the following error:

"Unable to start debugging on the web server.  The underlying connection was closed.  The connection was closed unexpectedly."

Any ideas on what I can try?  I've been doing research on the issue and Microsoft suggest making sure no other service is listening on the same ports.  I've verified that this isn't the issue.


Creating a Test server - Certain links getting redirected to live server.

  

Hi.

We had a website deployed on IIS server remotely say www.liveserver.com.

We recently decided to make a copy of the website internal to the organisation so we brought a server and copied all the code from live server and configured it and say it is http//archives-testserver.com


Everything seems to work fine but while navigating and clicking on certain module  links within  http//archives-testserver.com......the domain name is getting rewritten to www.liveserver.com and user is made to navigate on the live site. I wonder where this configuration is with in IIS...

I looked under properties under website identification and everything is referring it as http://arhives-testserver.com.  also thr is a file called securityRedirect.inc and ifor handling errors and all the references have been changed and couldn't find anything in web.config.


I would really appreciate if anyone can guide in right direction, where else to look for probable reference to live site?










will a 32-bit web application run as WOW64 on a 64-bit server?

  

Hi

I need to know if a web application deployed in a 64-bit server runs as a WOW64 process or a 64-bit process if the web application's pages are compiled as PE 32/x86 ?

I mean I have read a lot about normal console applications or executables with PE 32/x86 run as WOW64 on 64-bit servers. But what about web applications( all i can compile is the pages which are dlls)? The only process I can think of is w3wp.exe for web apps. Please explain. I am confused.

Thanks in advance

Vineeth


The remote server returned an error: (403) Forbidden.

  

Hi All,

i have a program in vb.net..i use the webrequest to post the data to another page (http://localpost/posReceived.aspx), and use the webResponse to get the back the response from the remote page.

When i run this program, it returned error "The remote server returned an error: (403) Forbidden.". I have no idea on this. Coz my aspx page and posReceived.aspx are placed in the same server and same directory. I supposed it should be worked without any security concerns.

Can anyone help me to solve it. Thanks a lot!

 

 

 


Problem with Server.Transfer in IE

  

I have the following code:

Protected Sub btnAdmin_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        Server.Transfer("~/Admin/Default.aspx")
End Sub

that runs when a user clicks the admin button

It works fine in firefox, but in IE it doesn't work.
 


Cannot insert the value NULL into column 'COUNTY', table 'TPI.dbo.juror_tmp'; column does not allow nulls. UPDATE fails.

  

I am attempting to bind data from a dropdown list that was populated from another datasourceID. I've bolded what I believe is relevant to this issue in the code below. But basicly its binding the proper county on the pull down menu but when I hit form submit it dosnt postback that info instead its null.

<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1"
            style="margin-right: 59px"
           CellPadding="4"
            ForeColor="#333333" DefaultMode="Edit" DataKeyNames="UID">
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <EditItemTemplate>
                Edit Item Template<br /><asp:Label ID="uidlabel" runat="server" Text='<%# Bind("uid") %>' /><br />
                last_date ha:
                <asp:TextBox ID="last_dateTextBox" runat="server"
                    Text='<%# Bind("last_date", "{0:d}") %>' AutoPostBack="True"
                    CausesValidation="True" />
                <br />
                first_name:
                <asp:TextBox ID="first_nameTextBox" runat="server"
                Text='<%# Bind("first_name") %>'
                    CausesValidation="True" ontextchanged="first_nameTextBox_TextChanged1" />
                <br />
                last_name:
                <asp:TextBox ID="last_nameTextBox" runat="server"
                    Text='<%# Bind("last_name") %>'
                    AutoPostBack="True"
                    CausesValidation="True" />
                <br />
                mi:
                <asp:TextBox ID="miTextBox" runat="server" Text='<%# Bind("mi") %>'
                    AutoPostBack="True" CausesValidation="True" MaxLength="1" />
                <br />
                home_phone:
                <asp:TextBox ID="home_phoneTextBox" runat="server"
                    Text='<%# Bind("home_phone") %>' MaxLength="9&

 
Categories:
.NET
Java
PHP
C/C++/VC++
HTML/XML
SAP
MainFrames
Data Warehousing
Testing
MySQL
SQL Server
Oracle
Javascript/VB Script
Others
Login
 
 
 
 
 Forgot password
 Contact Us   Terms Of use   Share your knowledge