Comments
Sort by recent activity
Sorry for the slow response to this post.
You should be able to include join candidates based on column name by enabling the option: Options > Listed Candidates > Join Conditions > Column Names.
Also, by default SQL Prompt has case sensitive filtering of objects enabled. This is why t.t didn't suggest t.T*. You can change this option in:
Options > Listed Candidates > Candidate Types and Filters > Enable case-sensitive filtering of candidates.
I hope this does what you need. / comments
Sorry for the slow response to this post.
You should be able to include join candidates based on column name by enabling the option: Options > Listed Candidates > Join Conditions > Column Names.
Al...
Thanks for your post.
There is the facility within SQL Data Compare 5 to clone an existing project. This will be effectively be using an already created project file as a template for a new project.
You can clone you projects by either clicking the 'create clone' button on the comparisons project screen, or on the same screen right-click the project and select 'create clone'.
I hope this answers your question. / comments
Thanks for your post.
There is the facility within SQL Data Compare 5 to clone an existing project. This will be effectively be using an already created project file as a template for a new project...
Thanks for your post.
There are two ways in which you can print your full SQL Doc documentation without needing to print every page individually.
The first method is to generate the documentation as a compiled HTML help file (CHM). You can then open this file and print using the print option 'Print the selected heading and all subtopics'.
If you want to use this method you need to make sure that you have the Microsoft® HTML Help Workshop installed on your computer. This can be downloaded from the Microsoft download centre.
The other method is to generate the documentation as HTML, then to expand the objects and print using the IE print option of 'all frames individually' (File > Print > Options > All Frames Individually).
I hope this helpful. Let me know if you need any more information. / comments
Thanks for your post.
There are two ways in which you can print your full SQL Doc documentation without needing to print every page individually.
The first method is to generate the documentation a...
I believe you are still working on this issue (#4125) with Brian in the support team.
I would like to assure you that the support team have access to the full resources of Red Gate, including assistance from the testers and developers if needed, so you can be confident that you are already dealing with the best people to find you a resolution. / comments
I believe you are still working on this issue (#4125) with Brian in the support team.
I would like to assure you that the support team have access to the full resources of Red Gate, including assis...
Thanks for your message.
When SQL Data Compare runs a comparison, it will automatically try to match up and compare objects based on the primary key that they have assigned. If the object in question does not have a primary key assigned, then SQL Data Compare will not know automatically what column to use as the key for comparison. This will show up in the comparison results as objects that could not be compared.
If you edit the comparison project and view the Tables & Views tab, look for any objects that have 'not set' in the comparison key column. These are all the objects that could not be automatically compared without manually choosing the comparison key. After you have chosen the comparison key, the objects will be compared in the project.
Once you have run the comparison, the manually assigned keys will be remembered for future executions.
I hope this answers your question. / comments
Thanks for your message.
When SQL Data Compare runs a comparison, it will automatically try to match up and compare objects based on the primary key that they have assigned. If the object in questi...
Thanks for your post.
As far as I am aware the shortcut keys are still valid in the most recent version of SQL Refactor, version 1.1. SQL Refactor is the tool that has functions such as lay out SQL. I would check the version you have of Refactor, and upgrade to the latest if necessary. For example, SQL Refactor 1.0 doesn't have support for SQL Server 2005 sp2.
SQL Prompt doesn't have any shortcut keys listed from the SQL Prompt menu bar in SSMS.
The version reported when using check for updates has been known to be a little unreliable. The development team are aware of this and are working on a solution for future versions. Using help > About is a far more reliable way of finding your version.
I hope this information is helpful. / comments
Thanks for your post.
As far as I am aware the shortcut keys are still valid in the most recent version of SQL Refactor, version 1.1. SQL Refactor is the tool that has functions such as lay out SQL...
At the moment SQL Compare will only compare at the object level, rather than the database or server level. However, introducing server level comparisons is something that the developers are very interested in introducing in a future version.
In response to your other question, if you want to create a package for a new database install, all you need to do is not tick the 'upgrade an existing database' option. This will create a package that will install the database from scratch on a SQL Server.
If you want to do this through SQL Compare, the best method would be to compare the schema to a blank database. This would mean that you wouldn't have to worry about excluding certain objects from the target database. / comments
At the moment SQL Compare will only compare at the object level, rather than the database or server level. However, introducing server level comparisons is something that the developers are very in...
Did you see the other forum post for the Specified cast is not valid error? http://www.red-gate.com/messageboard/vi ... php?t=3999
I think this should answer your question.
If you still have a problem, please let me know. / comments
Did you see the other forum post for the Specified cast is not valid error?http://www.red-gate.com/messageboard/vi ... php?t=3999
I think this should answer your question.
If you still have a probl...
I think you are right in thinking that the issue is to do with the size of the database.
As you are using a 1.5MB WAN for communication it might be a good idea to set up some of the log shipping outside of the Log Shipping Wizard to save on network resources.
What I would suggest is to take a full backup of the primary database, copy it to the DR server and restore WITH RECOVERY, OR WITH STANDBY. You could then use the log shipping wizard and select the newly restored standby database. This would mean that when you come to use the log shipping wizard the full database has already been copied across and restored, so it is just the jobs that get created through the Log Shipping Wizard.
I hope this is helpful. / comments
I think you are right in thinking that the issue is to do with the size of the database.
As you are using a 1.5MB WAN for communication it might be a good idea to set up some of the log shipping ou...
Thanks for your message.
It should be the frequency and date range set when running sp_deletebackuphistory, that determines how much of the backup history is deleted, rather than the erasefile option in a job. It might be worth checking the server option and see if that is also set to two days.
This sp is configured in the server option 'delete old backup history'. You should be able to set the deletion period for each server to choose how much history is retained. To get to the option right-click the server name and select options.
I hope this helps / comments
Thanks for your message.
It should be the frequency and date range set when running sp_deletebackuphistory, that determines how much of the backup history is deleted, rather than the erasefile opti...