Red Gate forums: SQL Source Control EAP

RE: Minor issues

sherr — Wed, 21 Jul 2010 12:29:59 GMT

FYI - The first issue of the bubble being shown when canceling the link has been fixed in the v1.0.3.73 patch release. More info about this release is available at http://www.red-gate.com/messageboard/viewtopic.php?t=11447.

RE: Sharing a Database using SMS on different workstations

rthorington — Fri, 02 Jul 2010 21:22:54 GMT

Don't count on SQL Compare Pro as a workaround. I'm getting the
"failed to locate the target table" error in SQL Compare Pro.

This is happening to me on several tables. It's rendering SQL Compare Pro unusable for source control (the whole reason for buying Pro).

Environment: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
Failures all occur on foreign keys for tables in a schema other than dbo, and referencing tables in that same (non-dbo) schema.

sherr wrote:

There's another situation that could cause this issue. It could happen if you commit an object, but do not commit its dependencies. This causes the version in source control to be in an invalid state, which we then have trouble parsing. You should be warned if there are dependencies when committing or getting and it is checked by default to include these.

Creating a new db and relinking does NOT help in this case.

WORKAROUND:
1) If you don�t have a lot of history in source control that you care about since this is an evaluation, then it might be better to just DELETE everything in source control and start again. This time when you commit an object, include its dependencies and hopefully you will get pass this issue.

2) If you want to keep your current history, do you have SQL Compare Pro? If so, you could script TableA to a scripts folder and then commit this to the Tables directory in SVN using TortoiseSVN. This should put the source control version back in a �valid� state and let you continue. If you don�t have SQL Compare Pro, script out the table using SSMS, and then Commit to SVN, but make sure it is named owner.tablename.sql like the other files are named.

RE: Question About Table Rebuild When Doing Get Latest

jfennell — Thu, 01 Jul 2010 21:06:28 GMT

Apologies for the slow turnaround on my part. I've just emailed the requested information. Please feel free to call me at the phone number in my email (East Coast, USA) if you have any questions.

SQL Source Control v1.0 Available!

Ben Adderson — Wed, 30 Jun 2010 10:05:09 GMT

SQL Source Control v1.0 is now available. It was released on June 30th 2010 after 6 months of Early Access and Beta Releases. It is powered by SQL Compare Pro and finally brings all the benefits of source control to database developers. Download it here.

Benefits:
� Completely integrated into SQL Server Management Studio
� Connect your database to your existing source control system (Subversion or Team Foundation Server)
� Know who changed what, when, and why
� Help the whole team stay in synch by easily getting the latest database version
� Save time and eliminate mistakes by deploying database changes using SQL Compare

Recommendations:
� Use your own local dedicated db for development. If you require a shared db or for more information about the dedicated model, see our whitepaper.
� Do not use SQL Source Control on your production database server.

Contact Us!
� Suggestion Forum - for new ideas and feature requests
� Support Forum - for any questions/problems you have (or email support@red-gate.com)

RE: Question About Table Rebuild When Doing Get Latest

jfennell — Fri, 25 Jun 2010 18:33:21 GMT

Stephanie,

Sorry, I should have known that you'd want to know that. I'm using Subversion. I'll pull a temporary copy of what SQL Source Control has in the repository and email it over with the snapshot.

Thanks,

RE: Question About Table Rebuild When Doing Get Latest

sherr — Fri, 25 Jun 2010 10:10:22 GMT

Hello,

What source control system are you using?

It's best to do a SVN Checkout or a TFS Get Latest to a temporary location on your computer. You can then zip up the files and email that to support@red-gate.com. You may want to rename the zip to *.zip.txt, so email filters don't strip the attachment. When we get the file, we'll remove the .txt so we can see the zip contents.

Thank you!
Stephanie M. Herr
Project Manager - SQL Source Control

RE: Question About Table Rebuild When Doing Get Latest

jfennell — Thu, 24 Jun 2010 18:12:08 GMT

Hi Stephanie,

I agree that the link you mentioned does not describe any situations that seem to apply here. I'll be glad to email you the information you requested. When you ask for "a copy of what's in source control," what's the best way for me to get what you're looking for?

Thanks,

RE: Question About Table Rebuild When Doing Get Latest

sherr — Thu, 24 Jun 2010 15:29:31 GMT

Hello Jim,

This is very strange...

We are using SQL Compare to commit/get. SQL Compare sometimes requires the table to be rebuilt, but this doesn't sound like your situation.

Would you be able email us a copy of what's in source control and a SQL Compare snapshot of your database so we can reproduce the problem here? This will only be used for our internal testing.

Email: support@red-gate.com
Internal Reference Number: SOC-1235

Thank you!
Stephanie M. Herr
Project Manager - SQL Source Control

RE: Params for table value functions causing errors.

jonmor — Thu, 24 Jun 2010 08:59:10 GMT

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ====================================================
-- Author: ***********
-- Create date: 10/10/2007
-- Description: Returns user details from the Config DB
-- for the passed in UserName or all
-- users if UserName not passed in
-- ====================================================
ALTER FUNCTION [udf_UserDetails]
(
@sUserName varchar(50) = NULL
)
RETURNS TABLE
AS
RETURN
(
SELECT U.sUserName as sUserName,
P.sFirstName as sFName,
P.sLastName as sLName,
P.sEmail as sEMail,
P.sFullName as sFullName,
U.bPermPriceEditor,
U.bAdmin,
U.sFavouritePCode,
U.iUID
FROM dbo.Users U
INNER JOIN dbo.CONFIG_DB_Person P
ON U.sUserName = P.sUserName
WHERE UPPER(U.sUserName) = UPPER(@sUserName)
OR @sUserName IS NULL
)

RE: Multiple SSMS Instances issue

simon.jackson — Thu, 24 Jun 2010 07:38:39 GMT

You can search UserVoice by typing in the 'Suggest a new feature or enhancement'. It searches as you type, in order to try and reduce the number of duplicate entries. I agree it's not the most obvious behaviour!

RE: Multiple SSMS Instances issue

cokert — Wed, 23 Jun 2010 20:56:58 GMT

Just found this.

http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/458976-multiple-instances-of-ssms?ref=title

Is there some way to search uservoice? Would seem like an obvious thing to have, but I couldn't find a way to do it.

Multiple SSMS Instances issue

cokert — Wed, 23 Jun 2010 20:51:02 GMT

I launched 2 instances of SSMS just now and Source Control is disabled in second instance.

That's an acceptable limitation for a v1.0 product IMO, but what I found annoying is this. I closed the original instance so that the second instance with SSC disabled was now the only instance. I couldn't find any way to get it to enable itself in the second instance, which was now the only instance. I ended up closing this instance as well and launching SSMS a third time.

Its not a huge problem by any means, but definitely what I would consider an annoyance and usability issue as its not clearly indicated that you won't be able to use SSC in that instance. The dialog is worded in such a way that made me think SSC would become available after closing the other instance, which it didn't.

For the future, I would like to be able to use multiple instances of SSC, though. I often run multiple instances of SSMS connected to different databases on different monitors. Not having SSC in those other instances will definitely be annoying.

Question About Table Rebuild When Doing Get Latest

jfennell — Wed, 23 Jun 2010 20:08:05 GMT

Hello,

I have a database under source control to which a new stored procedure was recently added on the remote (server) copy of the database. I am trying to use the "Get Latest" function to update my local copy of the database. When I go to the Get Latest tab under SQL Source Control for the database on my local system, the only change listed is the new stored procedure. When I try to perform the "Get Latest" function, SQL Source Control gives me a warning that it needs to rebuild one of the tables mentioned in the new stored procedure.

Why it would need to rebuild a table just to create a new stored procedure in the database? Shouldn't it be able to simply execute the CREATE PROCEDURE table?

I don't see a way for me to access the database change script it has generated; I thought that might give me some clues. The table in question contains filestream data in one of its columns and has A LOT of data in it, so the rebuild will take a considerable amount of time.

Can you help me explain why the table needs to be rebuilt just to add a new stored procedure?

Please let me know if there is any more information I can provide to help investigate this issue.

Thanks,

RE: Minor issues

sherr — Tue, 22 Jun 2010 18:50:53 GMT

Hello,

Thank you for reporting this issues. The first issue is definitely a bug. Our internal reference number is SOC-1163. This will not be fixed for v1, but you can just exit out of the help bubble.

For number 2, please vote/comment on these suggestions:
- A "Recent Messages" Button for Comments Like on TSVN
- Commit check in comment needs to be larger

Thank you!
Stephanie Herr
Project Manager - SQL Source Control

Minor issues

cokert — Tue, 22 Jun 2010 15:10:47 GMT

1. I cancelled out of the link database dialog, but sql source control showed the bubble saying the db was linked successfully.

2. Most source control programs I've used keep a history of your comments for reuse, which is handy. I didn't see that in the beta I'm using. Also, it would be helpful to have multi-line comments.[/list]