Comments
Sort by recent activity
Thank you for your post into the forum.
The machine running SQL Data Compare, will create temporarily files by default in the Windows Temp directory.
I would expect that these temp files would get overwritten, when you refreshed the compare result. Maybe the temp files are not getting overwritten and you are running out of space in the Windows Temp file directory. I will need to test for this and update you.
A support call has been created for you and the call reference number is F0032604
You can if you wish, set a system variable called RGTEMP and this action will force SQL Data Compare to use this new system variable. Useful if the machine running SQL Data Compare has 2 or more local disks and the local C: drive is short of disk space.
To set the system variable follow the steps below:
1. Right MyComputer and select Properties.
2. Select the Advanced Tab.
3. Click on the Environment Variables button.
4. In the System variables section, click on the new button.
5. For the 'Variable name' = RGTEMP
6. Type the path required for the New System Variable, for example [image] \RGTEMP.
7. Click OK to close New System Variable Dialog Box.
8. Click OK to close the Environmemt Variables Dialog Box.
9. Click OK to close the System Properties.
You may need to re-boot the machine for the system variable to take affect.
10. When you next start up SQL Data Compare (or any other Red Gate SQL Tools products, for example SQL Compare, SQL Doc or SQL Dependency Tracker) the temp files created will now be generated in the folder specified for the system variable RGTEMP.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
The machine running SQL Data Compare, will create temporarily files by default in the Windows Temp directory.
I would expect that these temp files would get ...
Thank you for your post into the forum.
To achive your goal, simply use the <database> file location tag to create a sub folder of the database name.
In the Copy To path simply add the <database> tag to the end of the path, for example:
\\MyServer\Share\<database>
This action will create a sub folder of the database name and copy the backup file into the new sub folder. Further information of the File Location Tags can be found in the SQL Backup Help Information.
I hope the above answers your question. / comments
Thank you for your post into the forum.
To achive your goal, simply use the <database> file location tag to create a sub folder of the database name.
In the Copy To path simply add the <database> t...
Thank you for your post into the forum.
SQL Backup exit code 870 indicates that no command was passed to SQL Backup. The command is empty.
So I suspect that you .Net application is not passing the commands correctly.
The command using your example needs to be as follows:
EXCUTE master..sqlbackup '-SQL "RESTORE DATABASE [testDB] FROM DISK = [\\testServer\SQLbackups\testDB.sqb] WITH STANDBY = [D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\\Undo_testDB.dat], DISCONNECT_EXISTING, MOVE [testeDB] TO [E:\SQLdata\testDB.mdf], MOVE [testDB_log] TO [E:\SQLLogs\testeDB_log.ldf], MOVE [testDB_2_Data] TO [E:\SQLdata\testeDB2_data.ndf], REPLACE, ORPHAN_CHECK" '
If you run the above code from a new query window and it is successful, the problem must be an error in your .Net code. I am not a programmer, so I cannot help with regards to your .Net code.
I hope this helps to answer your question.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
SQL Backup exit code 870 indicates that no command was passed to SQL Backup. The command is empty.
So I suspect that you .Net application is not passing the...
Thank you for your post into the forum.
Unfortunately (to my knowledge) there is no work around. SQL Compare can only compare two data sources at a time, thus you can only submit two data sources using the .xml argfile.
So you will need to submit an argfile .xml file for each comparison, so generating 1500 separate .xml files.
However you will be able to submit a single batch file that will before the 1500 comparisons in turn. Therefore perform the first comparison, when complete, move on to the second comparison and so on to the 1500th comparison.
Sorry to be the bearer of bad news. / comments
Thank you for your post into the forum.
Unfortunately (to my knowledge) there is no work around. SQL Compare can only compare two data sources at a time, thus you can only submit two data sources ...
Thank you for your post into the forum and sorry to hear that you experiencing a problem.
How strange that you can compare the live database but not take a snapshot.
Are you able to create the snapshot of this database if you specify another folder location on the same disk drive or to another folder located on a different disk?
We have have a free utility called Red Gate Snapper, that can create a SQL Compare snapshot files without having to use SQL Compare.
Red Gate Snapper can be downloaded using this LINK. Can you please download the utility and see if you can create a SQL Compare snapshot using Red Gate Snapper?
Many Thanks
Eddie / comments
Thank you for your post into the forum and sorry to hear that you experiencing a problem.
How strange that you can compare the live database but not take a snapshot.
Are you able to create the snap...
Thank you for your post into the forum.
Unfortunately SQL Server will prevent you from restoring a backup of a SQL 2008 database to a SQL 2005 database.
SQL Server itself performs the actual backup or restore operation. When using third-party backup solution like SQL Backup, SQL Server performs the back or restore using a virtual device.
For a backup task, SQL Server generates the backup data and informs SQL Backup where to find the data. SQL Backup will then compress and encrypt (if configured) before writing the compressed backup data to disk.
The restore the opposite occurs SQL Backup reads the backup file from disk, if the backup file is encrypted, that data is decrypted and uncompressed. SQL Backup informs SQL Server where to find the backup data for restore.
If you have a need to restore a SQL 2008 backup file to a SQL 2005 database, please take a look at our comparison tools SQL Compare and SQL Data Compare Professional Editions.
<http://www.red-gate.com/products/SQL_Compare/index.htm>
<http://www.red-gate.com/products/SQL_Data_Compare/index.htm>
You can compare the live SQL 2008 database with the live SQL 2005 database or compare the SQL 2008 backup file with a live SQL2005 database.
Using SQL Compare you can synchronize to database schema from the SQL 2008 database to the SQL 2005, providing that the schema is not using the new features available in SQL 2008.
Next use SQL Data Compare to synchronize the data from the SQL 2008 database to the SQL 2005.
I hope the above answers your question.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
Unfortunately SQL Server will prevent you from restoring a backup of a SQL 2008 database to a SQL 2005 database.
SQL Server itself performs the actual backup...
Thank you for your post into the forum.
Unfortunately indexes are included with the tables that created against and not as a separate object.
The only work around I can suggest would to edit the synchronization script generated so that only the index information remains.
I have added the details of this forum post to an existing feature request for SQL compare to treat indexes as a separate object. The feature request reference is SC-4562.
Hopefully the SQL Compare Product Manager and Development Team will consider the request for a future version of the product.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
Unfortunately indexes are included with the tables that created against and not as a separate object.
The only work around I can suggest would to edit the sy...
Thank you for your post into the forum and sorry that you have encountered a problem.
We have a created a support call for you, the call reference number is F0031764.
Can you please provide some logging details which may help identify the cause of the issue, as follows:
1. Open SQL Compare, cancel the project dialog that appears so that you have a blank SQL Compare window.
2. Click on the SQL Compare icon in the very top right hand corner above the file menu.
3. In the menu that appears, select the minimum logging levels and change the setting to Verbose.
4. Now select your project or create a new project and attempt to compare. When the problem occurs. Locate the log file, by default located in this folder:
C:\Documents and setting\<User_Name>\Local Settings\Application Data\Red Gate\Logs\SQL Compare
or by clicking on the SQL Compare icon in the very top right hand corner above the file menu and select the option to locate log files or Open current log file.
5. Send an e-mail to support@red-gate.com with your call reference F0031764 in the subject field of the e-mail with the log file attached.
Many Thanks
Eddie / comments
Thank you for your post into the forum and sorry that you have encountered a problem.
We have a created a support call for you, the call reference number is F0031764.
Can you please provide some lo...
Thank you for your post into the forum.
Can you please reply into this post, with details of the command line syntax you are using to perform the command line comparison?
A support call has been created for you, if you prefer to reply via e-mail, send an e-mail to support@red-gate.com and place the following call reference, F0031347, into the subject field of the e-mail.
Many Thanks
Eddie / comments
Thank you for your post into the forum.
Can you please reply into this post, with details of the command line syntax you are using to perform the command line comparison?
A support call has been cr...