User profile for Eddie D

Thank you for your post into the forum. A support call has been created for you. Can you please send your screen shot or picture to support@red-gate.com and include the following call reference number in the subject field of your e-mail, F0031346. In your e-mail reply, can you please provide information on the 3 columns that have been renamed. Many Thanks Eddie / comments

Thank you for your post into the forum. A support call has been created for you. Can you please send your screen shot or picture to support@red-gate.com and include the following call reference nu...

0 votes

Thank you for your suggestions. I have created a new Feature Request report. The Reference number is DT-577. I cannot guarantee that the request will obtain approval and if approval is given, in what future version of SQL Dependency Tracker the requested features will appear in. Thank you for taking the time to post your SQL Dependency Tracker suggestions. Many Thanks Eddie / comments

Thank you for your suggestions. I have created a new Feature Request report. The Reference number is DT-577. I cannot guarantee that the request will obtain approval and if approval is given, in w...

0 votes

Thank you for your post into the forum, however I littele confused as you inform that you are using SQL Data Compare and ask how to remove objects from SQL Compare. Although the products are similar in the way you select the data sources for comparison they are in fact two different products. In SQL Compare, to remove objects from the synchronization that exist only in the database to be synchronized. Perform the comparison and wait for the results to be displayed. The results will be spilt into 4 sections: Objects that exist in both data sources but are different. Objects that exist only in data source one or left hand data source. Objects that exsist only in data source two or right hand data source. Objects that are identical. So if you are synchronizing in the direction of left hand data source to the right data source. Expand the section for Objects that exsist only in data source two or right hand data source and uncheck the check boxes so that the object will not be included. Also when you run the Synchronization Wizard, look to see if the objects that you do not wish to be removed, are not included in the dependancy list as the object will be include. Uncheck the 'Include Dependencies' option. For SQL Data Compare, the results returned are similar to SQL Compare, in that you will for a table or view,you will have: Rows of data that exist in both data sources but are different. Rows of data that exist only in data source one or left hand data source. Rows of data that exsist only in data source two or right hand data source. Rows of data that are identical. So if you are synchronizing in the direction of left hand data source to the right data source. foe the table or view, look at the centre 3 columns: Rows of data that exist in both data sources but are different, the results are displayed in the middle column. Rows of data that exist only in data source one or left hand data source, the results are displayed in the column immediately to the left of the centre column. Rows of data that exsist only in data source two or right hand data source, the results are dispalyed in the column immediately to the right of the centre column. So if you wish these rows of data to remain, uncheck the check for the table or view. I hope the above answers your question. further advice can be found in the SQL Compare and SQL Data Compare help files. Many thanks Eddie / comments

Thank you for your post into the forum, however I littele confused as you inform that you are using SQL Data Compare and ask how to remove objects from SQL Compare. Although the products are simil...

0 votes

Thank you for your reply. When using the SQL Data Compare GUI for the first time, all of the possible results are selected for synchronization. Once you deselect the rows of data for each object, that exist only in the target. When you close the GUI. The selections you previously selected are saved. The next time you open the GUI, the options you previously set will remain, therefore in your example you would only need disregard the data that exists in the target or right hand data source just the once for that project. Alternatively, if you are licensed for the professional edition of SQL Data Compare, you can make use of the Command Line Line interface and create a script that will compare and synchronize the rows of data that exist only in data source 1 and exist in both but are different. As per this simple example: sqldatacompare /Database1:WidgetDev /Database2:WidgetLive /Synchronize /Include:Missing /Include:Different Have the script in a batch file and call the batch file when you need it. For more information on the SQL Data Compare Command Line Interface, please take a look in the SQL Data Compare Help File. Many Thanks Eddie / comments

Thank you for your reply. When using the SQL Data Compare GUI for the first time, all of the possible results are selected for synchronization. Once you deselect the rows of data for each object, t...

0 votes

Thank you for your post into the forum. An assertion error is very rare with regards to SQL Backup. Are there any entries in the SQL Server Error Logs and SQL Server VDI Logs that help in identifying the cause of the issue? Is this the first occurence? Or something you are experiencing intermittently? What version of SQL Server and service pack level of the server that generated this error? Many Thanks Eddie / comments

Thank you for your post into the forum. An assertion error is very rare with regards to SQL Backup. Are there any entries in the SQL Server Error Logs and SQL Server VDI Logs that help in identify...

0 votes

Thank you for your reply. The GUI on your acceptance server has two registered servers. A SQL Instance on the local machine and an instance from your DEV01 machine. It is the DEV01 instance where you wish to upgrade SQL backup. Simply open the GUI on the acceptance server, right click the server name for the DEV01 server and select option to delete. This action will remove the DEV01 server from the list of registered server in the acceptance GUI only. The server components installation will remain installed and the DEV01 GUI will still have the DEV01 listed as a registered. I hope the above answers your question. Many Thanks Eddie / comments

Thank you for your reply. The GUI on your acceptance server has two registered servers. A SQL Instance on the local machine and an instance from your DEV01 machine. It is the DEV01 instance where...

0 votes

Thank you your post into the forum. You do not need to remove registered servers. The upgrade from SQL Backup V5.4 to Version 6.3 is a two part process. You will need to upgrade both the SQL Backup GUI and the server components. So on the server that has a GUI and the only registered server is the local server, no problem simply upgrade the GUI and deploy the server componets to the registered server. On the machine that has multiple servers registered. Upgrade the SQL Backup GUI and then deploy the Server components to each of the registered servers. When you first re-open the GUI after upgrading it , it will bring a reminder box that the server components need to be upgraded. When you view the regsitered server, a cog icon will be displayed to the right of the server to indicate that an upgrade is available. If you have already upgraded the server components for the registered server, there will be no cog icon to the right of the server name in the registered servers panel. A new feature added to SQL Backup V6.3 is the ability to activate multiple servers, so if you have multiple servers regsitered into the GUI registered servers panel form the Tools menu ->Utilities ->Multi-server Activation. This new feature maybe useful to you, as by applying SQL Backup V6.*, activation is set back to trail license and you will need to re-activate after upgrading. This sticky forum post contains a link to a pdf document that contains upgrade instructions. It was originally written for upgrading to SQL backup V6.0/6.1 from previous versions. However the advice is still valid for you upgrading from V5.4 to V6.3: http://www.red-gate.com/messageboard/vi ... php?t=9346 Many Thanks Eddie / comments

Thank you your post into the forum. You do not need to remove registered servers. The upgrade from SQL Backup V5.4 to Version 6.3 is a two part process. You will need to upgrade both the SQL Backup...

0 votes

Thank you for your post into the forum. I have added the details of this forum post to an existing feature request seeking as you, to be able to log ship to multiple target databases. The reference for this feature request is SB-4455. I cannot guarantee that the feature request will be successful or in what future version the feature may appear in. Thank you for your suggestion. Many Thanks Eddie / comments

Thank you for your post into the forum. I have added the details of this forum post to an existing feature request seeking as you, to be able to log ship to multiple target databases. The referenc...

0 votes

Thank you for your post and sorry that you are experiencing a problem. Unfortunately I am unable to replicate the problem you are experiencing. By default in SQL Compare V8, the synchronization wizard is not available until the user selects one of more objects for synchronization. Once an object or objects are selected, the synchronization wizard button becomes available and clicking on the button, starts up the synchronization wizard. In Step 1, you select a synchronization method. From your post, I believe it is at this point that the 'next' button is not available? A support call, F0029913, has been created for us to investigate this issue further. Can you please, send an e-mail to support@red-gate.com with your call reference, F0029913, in the subject field of the e-mail and attach a screen shot of the step in the synchronization wizard with the 'next' button unavailable. Many Thanks Eddie / comments

Thank you for your post and sorry that you are experiencing a problem. Unfortunately I am unable to replicate the problem you are experiencing. By default in SQL Compare V8, the synchronization wiz...

0 votes

Thank you for your post into the forum. Have you tried editing your SQL Compare project and enabling the option to 'Force column order'? When this option is enabled, if additional columns are inserted into the middle of the table, this option forces a rebuild of the table so the column order is correct following synchronization. Data held in the table is preverved. Many Thanks Eddie / comments

Thank you for your post into the forum. Have you tried editing your SQL Compare project and enabling the option to 'Force column order'? When this option is enabled, if additional columns are inser...

0 votes

How can we help you today?

Eddie D

Comments