Comments
Sort by recent activity
Did the job contain a history of atleat 10 runs?
SQL Monitor will not raise the Job duration unusual alert until the job history contains at least ten runs.
See the notes section for job duration unusual. http://www.red-gate.com/supportcenter/Content?p=SQL%20Monitor&c=SQL_Monitor/help/3.0/SM_AlertsList.htm&toc=SQL_Monitor/help/3.0/toc1469820.htm
Also since the job never actually finished SQL Monitor would be unable to determine the percentage difference from the baseline because the duration of the job was ongoing.
I suppose the long running query alert may be able to catch this instance but there is no way to know for sure without knowing exactly what the job is doing. / comments
Did the job contain a history of atleat 10 runs?
SQL Monitor will not raise the Job duration unusual alert until the job history contains at least ten runs.
See the notes section for job duration u...
Yes, It is a new feature as of 10.1 I believe.
/scriptsfolderxml:<scriptsfolderxml> (Alias: /sfx)
[Deprecated] A file containing the script folder location XML fragment. / comments
Yes, It is a new feature as of 10.1 I believe.
/scriptsfolderxml:<scriptsfolderxml> (Alias: /sfx)
[Deprecated] A file containing the script folder location XML fragment.
This would be considered a feature request. You can submit the feature request to our user voice forum. If you request recieves enough votes our development team may add the feature to the a future release. http://redgate.uservoice.com/forums/141379-sql-compare-feature-suggestions
edit:
It *is* possible to specify this using /scriptsfolderxml. It involves copying the contents of the scripts folder extended property and referencing this using /scriptsfolderxml. http://www.red-gate.com/messageboard/viewtopic.php?t=15011 / comments
This would be considered a feature request. You can submit the feature request to our user voice forum. If you request recieves enough votes our development team may add the feature to the a future...
It is possible to set the temp folder.
Follow the link and there is a section called Changing the location of the temporary files. http://www.red-gate.com/supportcenter/content/SQL_Data_Compare/knowledgebase/getting_better_performance
Hope this helps. / comments
It is possible to set the temp folder.
Follow the link and there is a section called Changing the location of the temporary files.http://www.red-gate.com/supportcenter/content/SQL_Data_Compare/know...
Thank you for your feature request.
Please go to our user voice forum and submit your request http://redgate.uservoice.com/forums/141379-sql-compare-feature-suggestions
If your request recieves enough votes. Development may add the requested feature. / comments
Thank you for your feature request.
Please go to our user voice forum and submit your requesthttp://redgate.uservoice.com/forums/141379-sql-compare-feature-suggestions
If your request recieves enou...
I believe using the Generic - SQL Statement generator may be able to accomplish what you are looking for.
See here for more information. http://www.red-gate.com/supportcenter/Content?p=SQL%20Data%20Generator&c=SQL_Data_Generator/help/1.2/SDG_generic_generators.htm&toc=SQL_Data_Generator/help/1.2/toc52077.htm#o5532
Hope this helps. / comments
I believe using the Generic - SQL Statement generator may be able to accomplish what you are looking for.
See here for more information.http://www.red-gate.com/supportcenter/Content?p=SQL%20Data%20...
For each column in the 5th table that corresponds to data in another table you will set the Generator (the drop down at the top after selecting the column) to:
Sql Type-
Foreign Key (Manual) generator
From there you can set the table and column from which you want to populate data from into the column.
Hope this helps / comments
For each column in the 5th table that corresponds to data in another table you will set the Generator (the drop down at the top after selecting the column) to:
Sql Type-
Foreign Key (Manual) genera...
If I understand your question correctly you would like to populate the 5th table with data from the other four tables. If this is the case, you would select all 5 tables to populate but for each column referenced by data from another table in the 5th table you would set the generator to sql type - foreign (manual) key generator which allows you to populate the column with data from another column in another table.
For more information follow the link. http://www.red-gate.com/supportcenter/content/SQL_Data_Generator/help/2.0/SDG_About_generators / comments
If I understand your question correctly you would like to populate the 5th table with data from the other four tables. If this is the case, you would select all 5 tables to populate but for each co...
Unfortunately there is currently no way of comparing multiple databases in a single call of sqlcompare.exe. You can however specify the object type using the "/include" option when calling sqlcompare.exe through command line. If you are unfamiliar with the include option you can familiarize yourself by calling "sqlcompare /?" from the command line.
More information available at this link. http://www.red-gate.com/supportcenter/Content/SQL_Compare/help/10.0/SC_CL_Getting_Started / comments
Unfortunately there is currently no way of comparing multiple databases in a single call of sqlcompare.exe. You can however specify the object type using the "/include" option when calling sqlcompa...
What version of the tool are you on?
Can you try updating to the latest available version to see if the issue persists?
If you continue to experience your issue can you let it run at the point it gets stuck for a couple minutes and then send us the log file located here.
C:\Users\<username>\AppData\Local\Red Gate\Logs\SQL Source Control 3
You can email the log file to support@red-gate.com
Please include your supprt reference number F0070484 in the subject header. / comments
What version of the tool are you on?
Can you try updating to the latest available version to see if the issue persists?
If you continue to experience your issue can you let it run at the point it g...