Activity overview
Latest activity by SQL_ME_RICH
David, many thanks! / comments
David, many thanks!
Need installation file for build 11.6 (11.6.11.2463)
Version 12 no longer contains the Fast Deployment option, and my process needs it. I do not want to use the command line.
I do not have an executable for the version 11.6 installation any longer, ...
I've inherited a lot of really poorly designed databases (which is why I went with your tool as opposed to a baked-in HA solution for getting from point A to point [image] . The problem I have is that most of the databases are over 650GB in size, and not all of the tables in these databases have a primary key (so using a WHERE clause for the migrations of those tables is pretty much out), plus in my test where I could use a WHERE clause - it didn't buy me that much in cutting down the deployment time. I have had better results with simply using the IMPORT/EXPORT Wizard in SQL for WHERE clause migrations, so I split my migrations between your tool and that.
The Fast Deployment solution was a good way for me to run the process without having to wait for the Compare to complete, but now that it is gone from this new release - I've uninstalled it, and gone back to 11.6.x.x.
I have a massive migration coming up in the next month, and no time to waste on waiting for you guys to put this back in. As for the timestamp that I have asked for repeatedly for the Fast Deployment option, it would be nice to have (so you can see how long a migration takes without having to babysit the whole thing), but even with the request being up in your forum for new features - there was no traction on getting it added. I realize there are log files I can look at in the local profile, but they usually only show when things started - not when they ended. Timestamp feature request https://redgate.uservoice.com/forums/14 ... the-fast-d / comments
I've inherited a lot of really poorly designed databases (which is why I went with your tool as opposed to a baked-in HA solution for getting from point A to point . The problem I have is that mos...
And you base your end user usage stats on what? That is a major part of the deployments I do (so I don't have to baby sit them), and since the request for putting a timestamp on to the deployment window apparently never made it to being released either, it was the only way to migrate my larger databases (without having to physically be there to wait for the never ending compare process to complete).
I won't be using this new version then (and if all future versions of the same, we'll probably end up dropping the product all together).
Thanks a lot for making the migrations of larger database even more cumbersome.
:roll: / comments
And you base your end user usage stats on what? That is a major part of the deployments I do (so I don't have to baby sit them), and since the request for putting a timestamp on to the deployment ...
What happened to the Fast Deployment option?
Has it been dropped from this new version? Or is it hiding somewhere else now?
Check the task manager both before and after you start your tasks, and pay close attention to how many instances of svchost.exe you see (and especially what resources each is taking).
I don't know what version of Windows / Windows Server you are running, but I would start troubleshooting there. / comments
Check the task manager both before and after you start your tasks, and pay close attention to how many instances of svchost.exe you see (and especially what resources each is taking).
I don't know ...
Eddie, thank you! I will post something over there now. / comments
Eddie, thank you! I will post something over there now.
Filegroups: Any known issues when db's are different?
Hello -
Using SQL Data Compare 11.5.7.1288, and needing to migrate data from a 600GB database. The source db does not have the same file system as the target db. Are there any known issues when at...
Strange question perhaps, but much needed information. Glad to know that the connection to the source could be dead, and the process will not be killed (once it is at the point of generating the script).
Also - I have asked in the past for a feature to be installed in your Fast Deploy process, which would allow for a timestamp to mark the start and finish of the migration. Maybe that is something you guys could consider implementing in a future update to the product? For those of us who are at the mercy of waiting to see when it completes - we very rarely have the time to sit back, and do such babysitting (and knowing how long a migration takes is key to new system deployments - I doubt I am alone on that). I suppose I can always look at the properties of my database file (to see when it was last modified), but it would just be nice to know from your tool (just in case someone or something else does something to the file before I can get to it - I don't have to guess).
The dropping of the connection is not something I can do anything about, but knowing that so long as it has gotten to the point of Generating the script has the process in the clear, is good to know.
Thank you / comments
Strange question perhaps, but much needed information. Glad to know that the connection to the source could be dead, and the process will not be killed (once it is at the point of generating the s...
Fast Deploy - Source database connection question...
Hello -
Using SQL Data Compare 11.5.4.891. There are a series of steps that take place (before the script is eventually deployed to the target server). They are:
- Registering databases
- Mapping...