Red Gate forums

RE: Rollback scripts

John Palmer — Sat, 18 May 2013 17:15:32 GMT

EDIT: I'm sorry, after rereading your question, I now realize you wanted to be able to reverse a migration script. Sorry I missed that detail initially. I'll leave my somewhat out of context answer in the hopes that it may prove useful to someone!
--------------------------------------

As you noted, this isn't possible for all types of changes, but I've taken to using this technique with good success:

your_deploy_name.date.deploy.sql

Do not change any selections!

your_deploy_name.date.rollback.sql

You now have two script files, one to deploy and one to backout.

As an extra verification step, I have TeamCity running locally and use it and various RedGate tools to:

Smart Assembly Failed

jf3000 — Fri, 17 May 2013 22:58:49 GMT

This code in VS

Code:

Loading project C:\TDClient.saproj
Output=C:\Client.exe
Loading...
Starting...
Analyzing...
Preparing...
Creating assembly...
OK
-> C:\Client.exe
========== Build: 1 succeeded, 0 failed, 0 up-to-date, 0 skipped ==========

Produces this in Reflector

Code:

[assembly: Guid("32184934-6137-40f6-85b4-001951e249c2")]
[assembly: AssemblyProduct("Client")]
[assembly: AssemblyCompany("")]
[assembly: NeutralResourcesLanguage("en-AU")]
[assembly: ComVisible(false)]
[assembly: AssemblyTrademark("")]
[assembly: AssemblyCopyright("")]
[assembly: AssemblyFileVersion("1.0.0.0")]
[assembly: AssemblyDescription("Client")]
[assembly: AssemblyTitle("TDClient")]
[assembly: Debuggable(DebuggableAttribute.DebuggingModes.IgnoreSymbolStoreSequencePoints | DebuggableAttribute.DebuggingModes.Default)]
[assembly: CompilationRelaxations(8)]
[assembly: RuntimeCompatibility(WrapNonExceptionThrows=true)]
[assembly: TargetFramework(".NETFramework,Version=v4.5", FrameworkDisplayName=".NET Framework 4.5")]

In SA I added the DLL to the main exe and then moved the exe away from the DLL to check it and sure enough they werent added even though the exe grew because when I moved it away from the DLL it just crashed, didnt even get my error box reporter come up.

A bug?

RE: Profiling a different machine

jessica.ramos — Fri, 17 May 2013 21:10:02 GMT

I'm sorry to say that the Memory Profiler will need to be installed and running on the customer's machine. :/

RE: Oh Boy problems

jf3000 — Fri, 17 May 2013 20:34:38 GMT

Please close and review:

http://www.red-gate.com/MessageBoard/viewtopic.php?p=62009#62009

RE: Login failed for user when trying to open .sqlgen file

Manfred.Castro — Fri, 17 May 2013 20:09:45 GMT

You should be able to set password encrypted ="0" and then you can free type the password for the account.

<Password encrypted="0">your_unencrypted_password</Password>

schema compare and queue tables and queues

MelissaOlson — Fri, 17 May 2013 15:46:03 GMT

Hi,
Is there a way to set up my schema compare so that it will find my queues and queue tables?
Thanks!

RE: Is my .net app secure?

Chris.Allen — Fri, 17 May 2013 14:53:33 GMT

I can only refer to testimonials we've been given permission to publish. Please take a look at:

http://www.red-gate.com/our-company/about/all-testimonials

Force updates rather than inserts

dinonz — Fri, 17 May 2013 14:33:02 GMT

Hi,

I'm trying to do a comparison every 15 minutes and keep a target database up to date. I have fields whereby I can filter what has been added, and what has been changed in the last 15 minutes.

Problem is, adding that filter makes it want to "insert" all records that have changed, because they don't appear to be in the target data because they have not changed there. Is there a way to force the generation of SQL to always make update statement not inserts?

Dino

RE: Some methods in .app7results file are not exported to .htm

Brian Donahue — Fri, 17 May 2013 14:20:54 GMT

Hello Hein,

I'm curious to know if this is a problem with your web browser (not supporting JavaScript or some form of CSS). If you export to HTML whilst you are viewing the results in grid mode as opposed to tree mode, do you still have methods missing?

RE: 7.3.0.383 Issue: Refreshing Connection for 20m & counting

mglenn — Fri, 17 May 2013 13:51:54 GMT

Has Red-Gate looked into performance tuning sqbdata? Activity History still takes forever to populate--GT 5 minutes for us on a server that contains 1 year of history.

Customers should not be forced to delete important backup history as a workaround for a poorly performing SQL Backup process.