Best way to persist alter table changes in my local DB to web host

Hello.

Using SQL Server 2008.   I'm developing on my local PC with a copy of
the DB that is contained on a web host.  Is there a good way when I do
an alter table on the local DB to export that change to the web host
DB and have "semi-automatically" apply the change to its copy of the
table?

0
dontspammenow
1/16/2010 8:47:06 PM
sqlserver.programming 1873 articles. 0 followers. Follow

1 Replies
946 Views

Similar Articles

[PageSpeed] 33

dontspammenow@yahoo.com (dontspammenow@yahoo.com) writes:
> Using SQL Server 2008.   I'm developing on my local PC with a copy of
> the DB that is contained on a web host.  Is there a good way when I do
> an alter table on the local DB to export that change to the web host
> DB and have "semi-automatically" apply the change to its copy of the
> table?
 
There are a number of ways to do this. A solution which is popular with
many is to use Red Gate's SQL Compare. Personally, I prefer to keep my
code under version control, so it is not really my solution, but the
tool as such work very well.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

0
Erland
1/16/2010 9:54:06 PM
Reply:

Similar Artilces:

is there a way to zoom the Excel view to the current highlighted cells..with a single click
Never mind I found it zoom to selection I wonder f theres a way to hotkey (shortcut) this? Jery ...

is there a way to hide a whole worksheet in excel?
I would basically like to place all formulae on one worksheet and hide from anyone tempted to amend. most folks know how to unhide cells etc. Even if someone knows a sneakier way of making viewing of formula unviewable Good evening Marion McFarlane To hide a worksheet go to Format > Sheet > Hide. This can be unhidden through the same menu (but use unhide instead). To hide cells from view press ctrl + 1 and change the number format to Custom and ;;; (three semicolons). The formulae will still show in the status bar, so to hide from there, press ctrl + 1 and in the Protection ta...

Microsoft Office 2004 WEB COMPONENT
Hi, Will Microsoft OFFICE 2004 have the WEB COMPONENT Tool for SAFARI or INTERNET EXPLORER? Bye. In article <4002DCAE.C4F567EA@prova.com>, prova <prova@prova.com> wrote: > Will Microsoft OFFICE 2004 have the WEB COMPONENT Tool for SAFARI or > INTERNET EXPLORER? That hasn't been announced yet. However, since the Windows Office Web Component uses ActiveX technology, which doesn't work on Macs, I suspect it won't. ...

Best text books / manuals for MS Office (intermediate-Advanced use
What are the best (most highly reccomended) text books / instruction manuals you can get for Access, Excel, PowerPoint, Publisher, & Word and also VBE? I consider myself to be Quite proficient in Excel......Can produce a decent document in Publisher.......Can "Get by" in Word....Not enough knowledge of Access......Only used PowerPoint once....... I started using BASIC (the programming language) back in the '80s, so I have some knowledge of VBE (Formulas & syntax are quite simular from what I see now). I have created several Excel projects with Macros bu...

There must be a way.........
There must be a way to be sure all Vista and W7 system files are signed (not corrupted). I've researched and have not found a way. Can anybody help? <five256@NOwhere.com> wrote in message news:hb12r5tjthdtl87hlpgrcapq9b0hd87c4e@4ax.com... > There must be a way to be sure all Vista and W7 system files are signed > (not corrupted). I've researched and have not found a way. Can anybody > help? Yes, there is. It's called the System File Check tool. Read about system file protection here: http://support.microsoft.com/kb/222193 On Mon, 29 Mar 2...

The best photographer
He is the best famous photographer.. http://club.cyworld.com/dcnomad ...

Where is the best place to put notes?
We are new to MSCRM and are not used to all of the possible places that you can enter notes. Has anyone created a structure for their company as to what notes should be entered where? Wendy, There are many ways to handle notes. You have accurately identified that notes are kind of disjointed. What you might consider doing is creating a central notes depository in Sharepoint and then adding a customization with an inline frame that shows the Sharepoint notes repository in several different parts of CRM. In general, you have not provided enough information on what you are trying to ac...

Windows File Explorers could allow fonts face and color changes.
When I look at the desktop, I sometimes wish I could sort my files and folders. I imagine a system of boxes or cells to group items. The Desktop would look like a table of cells and the user would be able to put for example all the work files & folders in a cell, all the personal files&folders in another cell. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to ope...

How do you create an Outlook application object in my web page using VBscript?
How do you create an Outlook application object in my web page using VBscript? When I do the following code, I received an error "ActiveX component can't create object: 'Outlook.Application' ". The same code runs fine in VB 6. Thank you. <script language="VBScript"> set objOLApp = CreateObject("Outlook.Application") </script> The error means that the user may have IE set not to allow scripting of items not marked safe for scripting. If your code is running on a page on a site in the Trusted Sites zone, it should work OK (but check t...

Formula help in Excel which is the correct way ?
Tax is 23 % which is h-9 Total Cost is 75,000 which is b-9 I want to create a formula in B-11 that is 23% of total cost. So I did =H9*B$11 but apparently this isn't correct so what is the correct formula ?. need an absolute reference to H-7. So if you can give me the correct formula I would appreciate i -- SSVegett ----------------------------------------------------------------------- SSVegetto's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2822 View this thread: http://www.excelforum.com/showthread.php?threadid=47775 =$H$9*B9 Don't know wher...

what is the best way to resize test that "best fits" the text box
I just want to know how to resize text to fit the text box. Select the text and reduce the font size until it suits your requirements. There is no automatic function for this. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "utahjohn" <utahjohn@discussions.microsof...

Insert row, table to table
Hi, As I cannot use INSERT INTO with values specified to WHERE. I have created an interim temporary table where the record contains two text strings.Now I want to be able to take those text strings and append to the correct table where the record is set by an ID number. First_Name = Fred Last_Name = Jones Its a new contact so it is too be added to a customer with an ID = 1375 Now I can't use the following sql statement strsql = "INSERT INTO [tblCUSTCONTACTS] ( [FIRST_NAME], [LAST_NAME] ) " _ & " VALUES (""" & strFirst & "&...

Report writer
Hello, I am trying to add the transaction distribution details onto a copy of the PM Blank Document in Report Writer in GP 9. Would you pls advise as I can add the fields containing the data but the data is not appearing on the report. Thanks your comments are appreciated. -- chj@jup Once you were done modifying the report, did you give access to the mdoified report under Security? -- Lyle U chj wrote: > Hello, > > I am trying to add the transaction distribution details onto a copy > of the PM Blank Document in Report Writer in GP 9. Would you pls > advise as I c...

Changing IP address
We just changed ISP's and changed the IP address on the server. How no one can get to there e-mail, WHY? The server now has a 192 address and before has an external address. Care to provide more details, like type and version of client and server used, error messages (if any), name resolution setup etc? Bob wrote: > We just changed ISP's and changed the IP address on the server. How no one can get to there e-mail, WHY? The server now has a 192 address and before has an external address. -- Help fight spam - designate sending servers for your domain. http://spf.pobox.com The s...

Best way to forecast individual sales territories?
I have a spreadsheet with twelve months of sales data per territory (100 territories.) I need to forecast the next three months. The product being sold is just moving from launch phase to high growth phase, so it's still growing pretty quickly. What is the best method to forecast each individual territories' sales over the next three months? ...

Is there a "preferred" way to update properties based on other properties?
Let's say I have a class that represents a rectangle: class Rectangle { private int width; private int height; private int area; public int Width { get { return width; } set { width = value; } } public int Height { get { return height; } set { height= value; } } public int Area { get { return area; } } } Obviously, area does not represent anything based on that. How to best keep area in sync is the purpose of this question. One way would be to simply get rid of the variable area, and make the ...

OWA/OMA Protection
<No response from other forum> Hello, I have a Exchange 2003/OWA frontend that is protected with RSA two factor authentication inside a Checkpoint Firewall. The RSA part works fine and everything is good. Now I buy a Motorola Droid and need to set up the Exchange Sync and the RSA poses a problem. If I remove the RSA protection the Droid connects to the OWA and syncs well. Calls to RSA says it will not work with a Droid so I'd have to get rid of the RSA authentication. The question is: it looks like if I want to use a Android 2.0 based Droid phone to sync with outlook...

using multiple fields from a table
I am trying to use one table with multiple fields in a notinlist pop up. The name of the table is equipment. It has 2 fields in it, equipment and toners. No matter what I try, I get an error message saying the item is not on the list. If I change the statement strSQL = "INSERT INTO equipment([equipment]) " & _ "VALUES ('" & NewData & "');" to strSQL = "INSERT INTO equipment([toners]) " & _ "VALUES ('" & NewData & "');" I get the message, Th...

Pivot Table Avg only >0.000???
Excel 2000 ... Pivot Table ... My Pivot Table AVGs are being skewed down by an occassional "0.000" value appearing in the Col. Above said ... Is there a way to set the Pivot Table Field to only AVG those values >0.000??? Thanks ... Kha Ken, You can make a helper column with =IF(B2>0,B2,"") You can use the same heading as the original, so it will be the heading you want in the pivot table, and you can hide the column too. It may default to COUNT for the function, which you can change to average. -- Earl Kiosterud mvpearl omitthisword at verizon period net --...

GL figures
what really is the best practice method for brining in monthly GL figures so users can get comparative statements this year/lastyr. do you bring in all the old detail journals? or do you load via a maintenance or IM the historical balance for each month in some file. -- Linda W. Linda, You mean when you are starting up a new company? If so, unless someone needs the detail imported into GP for other reasons, I bring in a beginning balance and monthly net changes only. For example, let's say you're starting to use GP with January 2009, your fiscal year ends in December and y...

Error: Can't clean up the following tables: PriceLevel. 05-31-05
I cannot start CRM application. In error log ther is message Error: Can't clean up the following tables: PriceLevel. I tried to delete records with deletionstatecode = 2 in SQL and restarted SQL and CRM services bun nothing helps. Can someone help me? Thanks. Normally you don't have to directly interact with CRM Databases : it's not supported and can act on the MS CRM good operation. "Mikkhail" wrote: > I cannot start CRM application. In error log ther is message Error: Can't > clean up the following tables: PriceLevel. I tried to delete records with &...

Temp table and table variable
Hi, I have table variable with about 10 columns in my query and I'm using it only once. It has about 2000 rows. Query executes about 5 seconds. If I just change table variable into temp table and leave everything the same, query executes 100ms. How is that possible that it is so big difference in execution time? Maybe, because the query is new, it takes different execution plan now, and after a while the execution time would be the same - if so, there is the problem with statistics. How can I know what is the reason? Regards, Simon Simon, What is the query you are...

What converter do I need to change my QPW files to work in Excel 2
I had Quattro Pro (about 2003 -2004) on my computer when my hard drive crashed now I have Excel 2003. What converter do I need to change my QPW files to work in Excel 2003? puzzled Maybe the following will help....depending upon version of QP, I believe. You need the Quattro Pro convertors from MS. http://office.microsoft.com/en-ca/results.aspx?Scope=DC&Query=quattro+pro Then read this from Jim Rech http://snipurl.com/cz3x Gord Dibben Excel MVP On Mon, 12 Dec 2005 06:46:04 -0800, "puzzled" <puzzled @discussions.microsoft.com> wrote: >I had Quattro Pro (about...

Pivot Table with Pages
Hi TWIMC, How do I make my pivot table pages only show items that relate to the above selection, e.g. if I have three pages REGION, COUNTRY, ZONE, then if I select Europe I want my COUNTRY list to only show countries in EUROPE. TIA KM The page fields aren't dependent, and there's no way to change the setting. Kevin McCartney wrote: > Hi TWIMC, > How do I make my pivot table pages only show items that relate to the above selection, e.g. if I have three pages REGION, COUNTRY, ZONE, then if I select Europe I want my COUNTRY list to only show countries in EUROPE. > > T...

best tutorials for graphs ( line of best fit) for excel
What are the best tutorials for using excel for stastical analysis graphs and other graphs such as Line of best fit? Niccole: Here's a link to my chart gallery of Excel statistical charts. http://processtrends.com/TOC_chart_gallery.htm Here's a link to my page on trend analysis with Excel. This page shows several regression techniques that you can use with Excel. http://processtrends.com/toc_trend_analysis_with_Excel.htm Post back if you have more specific questions. Kelly O'Day koday at processtrends dot com "Niccole D" <Niccole D@discussions.microsoft....