Comments
Sort by recent activity
Hello Derek, Thanks for reaching out and sorry that you're having trouble with SQL Prompt. Can you confirm if you have the tab history option as well as the option to restore open tabs enabled in SQL Prompt>Options>Tabs>History? [image] Also,
are you using SQL Authentication as your connection method? If so, do
the tabs get restored if you use Windows Authentication? Lastly,
if you restore the SQL Prompt options to default (SQL Prompt
->Options->Restore all defaults), then restart SSMS, does it help? Kind regards, Pete Ruiz / comments
Hello Derek, Thanks for reaching out and sorry that you're having trouble with SQL Prompt. Can you confirm if you have the tab history option as well as the option to restore open tabs enabled in S...
Hi Guenter, We've managed to reproduce the
behavior using the example you provided and have escalated this to our
developers for review. We'll get back to you with further instruction. Kind regards, Pete Ruiz / comments
Hi Guenter, We've managed to reproduce the
behavior using the example you provided and have escalated this to our
developers for review. We'll get back to you with further instruction. Kind regar...
Hi @sgebling Thanks for the update. I'm glad you were able to get to the bottom of it. Please feel free to reach back out if anything else comes up. Kind regards, Pete Ruiz
Product Support Engineer
/ comments
Hi @sgebling Thanks for the update. I'm glad you were able to get to the bottom of it. Please feel free to reach back out if anything else comes up. Kind regards, Pete Ruiz
Product Support Engineer
Hello Steve, Thanks for reaching out and sorry
that you're having trouble with SQL Change Automation. When you first
create a new project and give it a name, you are then prompted to Get Started, you should exit out of this window and right click on the project in the solution explorer and select Unload Project. [image] [image] Then
you should follow the steps to edit the .sqlproj file and enable the
sync options you wish before reloading the project. Once this is done
you can then follow the steps to finish setting up the project rest of
the project. [image]
[image] I hope this is helpful. Please let me know if you have questions.
Kind regards,
Pete Ruiz
/ comments
Hello Steve, Thanks for reaching out and sorry
that you're having trouble with SQL Change Automation. When you first
create a new project and give it a name, you are then prompted to Get Started,...
Hello Mike, Thanks for reaching out and sorry
that you're having trouble with SQL Doc. You can try adding a semi-colon
at the end of the machine name\instance name and include
TrustServerCertificate=True like so: <machine name>\<instance name>;TrustServerCertificate=True Please confirm if this resolves the issue for you. If not, can you please try enabling Trust server certificate in the SQL Server>Connection Properties for the instance you're trying to connect to? [image] I hope this helps. Please let me know if you have any questions. Kind regards, Pete Ruiz / comments
Hello Mike, Thanks for reaching out and sorry
that you're having trouble with SQL Doc. You can try adding a semi-colon
at the end of the machine name\instance name and include
TrustServerCertifi...
Hello @Maurice , Thanks for reaching out and
sorry that you're having trouble with SQL Prompt. I'm having a little
trouble myself in trying to reproduce the issue. To clarify, is the
alias called, "[PCD_NEDAP_RELATION]", actually an alias? If so, where is
it defined? Also, can you kindly clarify how the synonym called
"[dbo].[SE_PCD_NEDAP_RELATION]" relates to the alias that isn't being
resolved? Would you mind sharing a sample script to assist in
reproducing the issue that we can pass on to our development team for
further review?
Kind regards,
Pete Ruiz Redgate Product Support / comments
Hello @Maurice ,Thanks for reaching out and
sorry that you're having trouble with SQL Prompt. I'm having a little
trouble myself in trying to reproduce the issue. To clarify, is the
alias called...
Hello @BartmanDilaw , Thanks for reaching out and sorry that you're having trouble with Source Control for Oracle. Unfortunately
at this time, the Oracle Tools do not support Scheduled Jobs or
Database Links. So sorry for any inconvenience. I have included URL's to the Oracle Tools UserVoice topics so that you can vote for these features. https://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/7030916-support-jobs https://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/7030916-support-jobs https://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/3793108-add-versioning-support-for-database-links Please let me know if there are any further questions.
Kind regards,
Pete Ruiz
/ comments
Hello @BartmanDilaw ,Thanks for reaching out and sorry that you're having trouble with Source Control for Oracle. Unfortunately
at this time, the Oracle Tools do not support Scheduled Jobs or
Da...
Hello @darber , Thanks for reaching out and sorry that you're having
trouble with SQL Source Control. Would you happen to recall in which
version you had the option to modify the migration script from the
failed 'Apply Changes' window? I looked through our documentation and
couldn't find when this changed. You can edit the migration by clicking
on the migrations tab and select view/edit on the migration script
you're getting the error from, however, after testing this locally, I
don't believe this will help your issue. We don't believe the use
statement makes sense for SQL Source Control because the scripts folder
can be used against any database. We actually removed the option to add a
database use statements for this reason. Would it be possible
to remove the use statement from the script all together? Please keep in
mind, once you modify the script you have to commit it before you can
apply the change. I hope this helps. Please let me know if there are any further questions. Kind regards, Pete Ruiz / comments
Hello @darber ,Thanks for reaching out and sorry that you're having
trouble with SQL Source Control. Would you happen to recall in which
version you had the option to modify the migration script ...
Hello @MikeM , Would love to hear back from you on how it goes. Good luck! Cheers,
Pete Ruiz
/ comments
Hello @MikeM ,Would love to hear back from you on how it goes. Good luck!Cheers,
Pete Ruiz
Hello @MikeM Thanks for reaching out. Unfortunately,
this isn't something SQL Compare is able to do and I'm not aware of an
available tool that can do this. However, you might be able to
accomplish this using a batch file or PowerShell script perhaps that
will run a compare for all your databases from dev to prod one after
another. I hope this helps. Please let me know if there are any further questions. Kind regards, Pete Ruiz / comments
Hello @MikeMThanks for reaching out. Unfortunately,
this isn't something SQL Compare is able to do and I'm not aware of an
available tool that can do this. However, you might be able to
accompli...