Activity overview
Latest activity by Manfred.Castro
Hi Jack,
SQL test 1.5 should include the latest tSQLt framework.
Were you using these databases with SQL Test 1.0?
If so, you will need to manually upgrade the tSQLt framework for these databases.
To upgrade the tSQLt framework you will need to uninstall and reinstall the tSQLt framework.
Please see the following page for details on upgrading the tSQLt framework. http://documentation.red-gate.com/displ ... ease+notes
Manfred / comments
Hi Jack,
SQL test 1.5 should include the latest tSQLt framework.
Were you using these databases with SQL Test 1.0?
If so, you will need to manually upgrade the tSQLt framework for these databases.
...
Hi Brian,
The location of the temporary files is defined by the RGTEMP environment variable, or the TMP variable if RGTEMP does not exist (see your Windows documentation for information about environment variables).
You are not recommended to edit the TMP variable, as this will affect all programs that use the variable. Instead, you can create a new environment variable called RGTEMP, and specify the location. The RGTEMP variable should redirect the temp directory for all Red Gate programs.
Note:
You may need to log out of Windows for the change to take effect.
Manfred / comments
Hi Brian,
The location of the temporary files is defined by the RGTEMP environment variable, or the TMP variable if RGTEMP does not exist (see your Windows documentation for information about envir...
Hi Avi,
Your issue could be related to the scripts that represent your database and/or repository
Can you try unlinking and relinking the database from source control?
That should force the tool to rebuild these scripts.
If that doesn't help, do you get the option submit an error report?
Can you invoke the error, submit the error report and include your email address so that I can find it in our error reporting system.
Manfred / comments
Hi Avi,
Your issue could be related to the scripts that represent your database and/or repository
Can you try unlinking and relinking the database from source control?
That should force the tool to...
Is it possible to compare these tables while ignoring leading spaces?
Unfortunately it is not possible to ignore the leading whitespace in a string.
There is an option to ignore trailing white space however this will only ignore spaces at the end of the string.
If you wish you can request the feature to ignore leading whitespace in our uservoice forum. http://redgate.uservoice.com/forums/147 ... ta-compare
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
If not I was planning to copy tables to same source and manually trim spaces before comparing. Is there better way?
Alternatively you could create a view and use the view in the comparison. Provided you enable the option to "Include views". Then map the view to the table in object mapping. http://documentation.red-gate.com/displ ... ct+options
Manfred / comments
Is it possible to compare these tables while ignoring leading spaces?
Unfortunately it is not possible to ignore the leading whitespace in a string.
There is an option to ignore trailing white spac...
Try
SET @... = '-SQL "RESTORE DATABASE ' + @databasename + ' FROM DISK = ''''\\kprod-nas03\sqlbackups\' + @sitename + ''''' WITH PASSWORD=''''fjfelejl'''' SOURCE = ''''' + @DatabaseName + ''''', MOVE DATAFILES TO ''''D:\SQLData'''' , MOVE LOGFILES TO ''''D:\SQLLogs'''' ,
MAILTO = ''''pam.ozer@kareo.com'''', RECOVERY,
CHECKDB = ''ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS''' / comments
Try
SET @... = '-SQL "RESTORE DATABASE ' + @databasename + ' FROM DISK = ''''\\kprod-nas03\sqlbackups\' + @sitename + ''''' WITH PASSWORD=''''fjfelejl'''' SOURCE = ''''' + @DatabaseName + ''''', MO...
What is the statement generated?
I think you are missing some single quotes.
Try
SET @... = '-SQL "RESTORE DATABASE ' + @databasename + ' FROM DISK = ''''\\kprod-nas03\sqlbackups\' + @sitename + ''''' WITH PASSWORD=''''fjfelejl'''' SOURCE = '''' + @DatabaseName + '''', MOVE DATAFILES TO ''''D:\SQLData'''' , MOVE LOGFILES TO ''''D:\SQLLogs'''' ,
MAILTO = ''''pam.ozer@kareo.com'''', RECOVERY,
CHECKDB = ''ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS''' / comments
What is the statement generated?
I think you are missing some single quotes.
Try
SET @... = '-SQL "RESTORE DATABASE ' + @databasename + ' FROM DISK = ''''\\kprod-nas03\sqlbackups\' + @sitename + ''...
Looks like your command has two "WITH" statements
TRY
SET @... = '-SQL "RESTORE DATABASE ' + @databasename + ' FROM DISK = ''\\kprod-nas03\sqlbackups\' + @sitename + ' WITH PASSWORD=''fjfelejl'' SOURCE = ''' + @DatabaseName + ''', MOVE DATAFILES TO ''D:\SQLData'' , MOVE LOGFILES TO ''D:\SQLLogs'' ,
MAILTO = ''pam.ozer@kareo.com'', RECOVERY,
CHECKDB = ''ALL_ERRORMSGS, DATA_PURITY, EXTENDED_LOGICAL_CHECKS''' / comments
Looks like your command has two "WITH" statements
TRY
SET @... = '-SQL "RESTORE DATABASE ' + @databasename + ' FROM DISK = ''\\kprod-nas03\sqlbackups\' + @sitename + ' WITH PASSWORD=''fjfelejl'' SO...
Hi Eric,
Unfortunately we do not have a beta available for SQL Data Compare.
We should have a full release version out within the next couple of weeks though.
Sorry for any inconvenience this may have caused.
Manfred / comments
Hi Eric,
Unfortunately we do not have a beta available for SQL Data Compare.
We should have a full release version out within the next couple of weeks though.
Sorry for any inconvenience this may h...
Hi Dmitri,
Unfortunately there is not currently any canned generator we provide that can accomplish what you are attempting to accomplish.
You can request a feature for this type of generator in our forums. http://redgatesupport.red-gate.com/foru ... -Generator
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
You could try to write your own Python script to generate data the way you want. http://documentation.red-gate.com/displ ... tgenerator
Manfred / comments
Hi Dmitri,
Unfortunately there is not currently any canned generator we provide that can accomplish what you are attempting to accomplish.
You can request a feature for this type of generator in ou...
Hi Richard,
Are you using the tool to sync or generating a script and then syncing via SSMS?
It sounds like it could be an encoding issue.
You may want to try changing the encoding of the deployment scripts in your Application options.
Located in Tools -> Application options
I am not really sure which encoding option you will have to select so you may need to try each one to see if you get a better result.
Manfred / comments
Hi Richard,
Are you using the tool to sync or generating a script and then syncing via SSMS?
It sounds like it could be an encoding issue.
You may want to try changing the encoding of the deploymen...