179 results found

1. "Failed to update" message after encountering a ";" in a stored procedure

   Ran into an issue when entering a stored procedure with a semi colon in it.

   Failed to update:

   oEc.#8Jf: Errors occured whilst parsing file C:\Documents and Settings\Adam\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\4c857d86-7cf5-464b-86bc-01d4f22d1423\Stored Procedures\Article.GetArticlesByKewords.sql

   'line 47:2: unexpected token: [";",<631>,line=47,col=2] [char=1276]'
   ---> cZ: Errors occured whilst parsing file C:\Documents and Settings\Adam\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\4c857d86-7cf5-464b-86bc-01d4f22d1423\Stored Procedures\Article.GetArticlesByKewords.sql
   'line 47:2: unexpected token: [";",<631>,line=47,col=2] [char=1276]'
   ---> line 47:2: unexpected token: [";",<631>,line=47,col=2] [char=1276]
   --- End of inner exception stack trace ---
   at #oEc.#7Jf.#t.#B3.#sKf()
   at #oEc.#7Jf.#gKf(Action action)
   --- End of inner exception stack trace ---

   Server stack trace:
   at #eEc.#fEc.#t.#izb.#j5f()
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

   Exception rethrown at [0]:
   at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsThrowAll(Action action)
   at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token)

   For your information, the following is the text in the stored procedure....

   -- =============================================
   
   -- Author: <Chandrashekar>
   
   -- Create date: <10 Jun 2009>
   
   -- Description: <Get Articles By Kewords and Section >
   
   -- =============================================
   
   CREATE Procedure [Article].[GetArticlesByKewords]
   
   (
   
   @Keywords varchar(max) = '',
   
   @Section varchar(50) = Null,
   
   @ArticleId int = Null, --For Suppressing Articles
   
   @CountID int = Null,
   
   @IncludeDeleted bit = 0
   
   )
   
   As
   
   /*
   
   SELECT
   
   distinct c.contentid as contentid,
   
   c.titlebox1 as title,
   
   c.section as section,
   
   c.keywords as keyword,
   
   c.priority as priority,
   
   article.section.SectionName as description
   
   FROM
   
   content c
   
   CROSS APPLY dbo.Csvtovarchar(@Keywords) r
   
   INNER JOIN content On c.keywords LIKE '%' + r.VarCharValue + '%'
   
   INNER JOIN article.section ON article.section.SectionCode =c. section-- @Section
   
   WHERE c.contenttype='ARTICLE'
   
   AND
   
   (
   
   (@Section IS NULL )OR
   
   (@Section IS NOT NULL AND c.section LIKE '%' + @Section + '%' )
   
   )

   AND
   
   (
   
   (@ArticleId IS NULL )OR
   
   (@ArticleId IS NOT NULL AND c.contentid <> @ArticleId )
   
   ) */

   ;

   With cte (rank,contentid,title,section,keyword,priority,description)
   
   As (
   
   SELECT
   
   --row_number() Over(Order by c.priority),
   
   rank() Over(Order by c.contentid ),
   
   c.contentid as contentid,
   
   c.titlebox1 as title,
   
   c.section as section,
   
   c.keywords as keyword,
   
   c.priority as priority,
   
   article.section.SectionName as description
   
   FROM
   
   content c
   
   CROSS APPLY dbo.Csvtovarchar(@Keywords) r
   
   --INNER JOIN content On c.keywords LIKE '%' + r.VarCharValue + '%'
   
   INNER JOIN article.section ON article.section.SectionCode = c. section-- @Section
   
   WHERE c.contenttype='ARTICLE'
   
   And c.keywords LIKE '%' + r.VarCharValue + '%'
   
   AND
   
   (
   
   (@Section IS NULL )OR
   
   (@Section IS NOT NULL AND c.section LIKE '%' + @Section + '%' )
   
   )

   AND
   
   (
   
   (@ArticleId IS NULL )OR
   
   (@ArticleId IS NOT NULL AND c.contentid <> @ArticleId )
   
   )
   
   And
   
   (
   
   (@IncludeDeleted = 1) Or
   
   (c.priority > 0)
   
   )
   
   )
   
   Select Distinct
   
   contentid, title, section, keyword, priority, description
   
   FROM CTE
   
   Where (@CountID Is Null) Or (@CountID >= rank)

   Looking at the procedure, it shouldn't have a semi colon where it does, but still I would expect the application to be able to handle it.

   Ran into an issue when entering a stored procedure with a semi colon in it.

   Failed to update:

   oEc.#8Jf: Errors occured whilst parsing file C:\Documents and Settings\Adam\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\4c857d86-7cf5-464b-86bc-01d4f22d1423\Stored Procedures\Article.GetArticlesByKewords.sql

   'line 47:2: unexpected token: [";",<631>,line=47,col=2] [char=1276]'
   ---> cZ: Errors occured whilst parsing file C:\Documents and Settings\Adam\Local Settings\Application Data\Red Gate\SQL Source Control 0\WorkingBases\4c857d86-7cf5-464b-86bc-01d4f22d1423\Stored Procedures\Article.GetArticlesByKewords.sql
   'line 47:2: unexpected token: [";",<631>,line=47,col=2] [char=1276]'
   ---> line 47:2: unexpected token: [";",<631>,line=47,col=2] [char=1276]
   --- End of inner exception stack trace ---
   at #oEc.#7Jf.#t.#B3.#sKf()
   at #oEc.#7Jf.#gKf(Action action)
   --- End of inner exception stack trace ---

   Server stack trace:
   at #eEc.#fEc.#t.#izb.#j5f()
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[]… more

   9 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   This has been fixed in EA2 (v0.2.1), which was released on Mon 22 Feb 2010.

2. Error Linking to a DB already in source control

   I had disconnected a DB from source control due to performance issues. I have a work-around supplied by RG tech support. When I tried to re-link, I got this message and I am unable to link to the DB in source control.

   Failed to update:

   oEc.#8Jf: Failed to locate the target table [dbo].[Transaction] for the FKTransactionDataTransaction foreign key. ---> RedGate.SQLCompare.Engine.SqlCompareException: Failed to locate the target table [dbo].[Transaction] for the FKTransactionDataTransaction foreign key. ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1435, offset:37 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 211, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1369, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 210, offset:30 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 213, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 773, offset:61 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 757, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 771, offset:14 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1514, offset:36 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1357, offset:63 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 165, offset:468 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1507, offset:800 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1373, offset:18 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 211, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 215, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1205, offset:143 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1204, offset:6 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 958, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 957, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1455, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1359, offset:117 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 149, offset:11 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 186, offset:137 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 930, offset:22 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1633, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1002, offset:500 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1006, offset:109 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1008, offset:22 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1010, offset:13

   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at #oEc.#7Jf.#t.#B3.#sKf()
   at #oEc.#7Jf.#gKf(Action action)
   --- End of inner exception stack trace ---

   Server stack trace:
   at #eEc.#fEc.#t.#izb.#j5f()
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

   Exception rethrown at [0]:
   at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsThrowAll(Action action)
   at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token)

   I had disconnected a DB from source control due to performance issues. I have a work-around supplied by RG tech support. When I tried to re-link, I got this message and I am unable to link to the DB in source control.

   Failed to update:

   oEc.#8Jf: Failed to locate the target table [dbo].[Transaction] for the FKTransactionDataTransaction foreign key. ---> RedGate.SQLCompare.Engine.SqlCompareException: Failed to locate the target table [dbo].[Transaction] for the FKTransactionDataTransaction foreign key. ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1435, offset:37 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 211, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1369, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @

   … more
   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   This has been fixed in v1.0. (SOC-594)

3. Commit check in comment needs to be larger

   text area too small- didnt even notice it. Would be good to have multiline comments.

   60 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   6 comments  ·  Delete…  ·  Admin →
   completed  ·  Tanya Joseph responded

   This is available in SQL Source Control v2.1

4. Very easy to use and install

   I think this product is brilliant and delivers simple version control for databases - something that has always been lacking. I do agree though that it would be nice to have more SVN options via the SQL Server interface

   4 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   Thanks for your feedback! It’s great to hear! :-)
   I’m closing this suggestion so you can have your votes back…

5. Integration with SQL Refactor/SQL Prompt's "Smart Rename"

   Integration with SQL Refactor is crucial. Smart Rename should be noted by SQL Source Control and a commit should do a rename on the object in SVN to keep commit comments.

   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Delete…  ·  Admin →
   completed  ·  Chris Smith responded

   SQL Source Control 3.0 is now available!

   It includes a new feature called ‘Migrations’ that will help avoid data loss when renaming a table as it allows you to create, store and share SQL change scripts for accurate deployment.

   For more information about Migrations, please visit:
   http://www.red-gate.com/supportcenter/Content/SQL_Source_Control/help/3.0/SSC_Working_With_Migrations

6. Actions in a submenu would be useful

   I can right-click on a database (or item within) in Object Explorer and see a choice labelled "SQL Source Control", but all it does is open the tab in the main area. It would be great if it also had a submenu (like TortoiseSVN does in Windows Explorer) which offered "Update", "Commit", "Show log", "Diff", "Revert", "Delete" and so on. Actually it would be great if the latter actions were offered at all (show log, diff, etc.) because to do them now, I need to jump over to Windows Explorer and use Tortoise.

   50 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   6 comments  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   In EA2 (v0.2.1), we added Commit and Get Latest to the Object Explorer right click menu. If you would like other features, please vote/comment on the following (we would need to implement these first before adding them to the right click menu):
   Revert/Undo Pending Change – http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/491513-revert-undo-pending-change
   Show Log/History – http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/471982-tab-for-svn-log-show-history-
   Open DB from Source Control – http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/459952-open-a-database-from-source-control
   Diff/Compare with previous version – http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/491523-diff-or-compare-versions-of-an-object

7. Support of Continuous Integration

   We evaluate SQL Source Control in an internal project and it already saves us a lot of time in our daily development work.

   On top of our subversion we use a Continuous Intregration Server so it would be great if we could trigger SQL Source Control by that Server. A simple command line tool with some parameters would be sufficient to automatically sync a test database with the subversion so that afterwards a couple of SQL test scripts could be executed.

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  0 comments  ·  Delete…  ·  Admin →

8. allow start entering commit comment while sql source control "determining latest version" and so on.
   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

   This feature is now available as of v1.1.0.19. Please use Help > Check for Updates on the SQL Source Control tab within SSMS to make sure you have the latest version.

   Thank you!

9. Access My Working Folder From SSMS

   A link to the windows folder where the database repository is stored would be good too.

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   completed  ·  Chris Smith responded

   SQL Source Control has a hidden option that allows you to open the linked database’s working folder from SSMS. See comments for how to find this option.

10. Support for SQL 2008 R2
    26 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    EA4 (and later) now supports SSMS 2008 R2! Email SqlSourceControlSupport@red-gate.com if you need the download link.

11. Crash (unrecoverable) after checking in some objects, but not dependencies

    Message shown after Registering Live Database stage of refreshing display.

    Failed to update:

    oEc.#8Jf: Failed to locate the target table [dbo].[tbNMI] for the FKtbNMINSRDtbNMI foreign key. ---> RedGate.SQLCompare.Engine.SqlCompareException: Failed to locate the target table [dbo].[tbNMI] for the FKtbNMINSRDtbNMI foreign key. ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1435, offset:37 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 211, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1369, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 210, offset:30 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 213, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 773, offset:61 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 757, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 771, offset:14 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1514, offset:36 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1357, offset:63 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 165, offset:468 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1507, offset:800 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1373, offset:18 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 211, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 215, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1205, offset:143 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1204, offset:6 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 958, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 957, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1455, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1359, offset:117 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 149, offset:11 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 186, offset:137 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 930, offset:22 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1633, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1002, offset:500 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1006, offset:109 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1008, offset:22 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1010, offset:13

    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    --- End of inner exception stack trace ---
    at #oEc.#7Jf.#t.#B3.#sKf()
    at #oEc.#7Jf.#gKf(Action action)
    --- End of inner exception stack trace ---

    Server stack trace:
    at #eEc.#fEc.#t.#izb.#j5f()
    at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
    at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
    at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

    Exception rethrown at [0]:
    at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsThrowAll(Action action)
    at #JLc.#PLc.#CTc(ICancellableOperation`1 operation, Object token)

    Message shown after Registering Live Database stage of refreshing display.

    Failed to update:

    oEc.#8Jf: Failed to locate the target table [dbo].[tbNMI] for the FKtbNMINSRDtbNMI foreign key. ---> RedGate.SQLCompare.Engine.SqlCompareException: Failed to locate the target table [dbo].[tbNMI] for the FKtbNMINSRDtbNMI foreign key. ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1435, offset:37 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 211, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1369, offset:0 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 210, offset:30 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 213, offset:38 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 773, offset:61 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 757, offset:31 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 771, offset:14 ---> SmartAssembly.SmartExceptionsCore.UnhandledException: SmartExceptionsCore.UnhandledException @ 1514, offset:36

    … more
    2 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Delete…  ·  Admin →

12. Works very intuitively

    Adding a database to a repository and doing the first commits works very intuitively. Great job!

    14 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    Thanks for your feedback! It’s great to hear! :-)
    I’m closing this suggestion so you can have your votes back…

13. Changes to dbo schema can't commit

    After granting the dbo schema rights to a userdefined role I can't commit it

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    This has been fixed in the latest release.

    Thank you!

14. Create Database from source control using the command line

    It would be great if it would be possible to create a database from source control using the command line interface (or some api).

    2 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

15. BUG: Objects with extended properties can't be committed

    When adding extended properties to tables (like an svn keyword) it fails to commit

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    We think this issue has been fixed in v1.0. If you are still experiencing any problems, please contact support@red-gate.com.

16. Crash with Analysis Services

    When I try to open up an analysis services database (to view), SQL Source Control crashes.

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    This was fixed in v0.2.1. Please upgrade to the latest version by clicking Help > Check for Updates.

17. "create to new link to source control" link not enabled

    can't set up my link to the source control:

    http://i.imgur.com/Uy7wY.jpg

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    The links are disabled until a user selects a database in Object Explorer.

18. Where are the credentials coming from?

    After I connect to a database, everything works very intuitively. In fact it's so intuitive that I see my account used for commits, but I'm not sure where it found my login credentials. Is there a way to use a different set of credentials if you have multiple svn accounts?

    2 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

19. Thank you!

    http://www.youtube.com/watch?v=DpJyG7B6tAI

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminRedgate Administrator (Admin, Redgate) responded

    Thanks for your feedback! It’s great to hear! :-)
    I’m closing this suggestion so you can have your votes back…