Red Gate forums: SQL Toolkit Previous Versions

RE: Could not find a part of the path

Anu Deshpande — Wed, 24 Apr 2013 08:40:22 GMT

Many thanks for your post and apologies for the inconvenience caused.

What version of Source control you are on?

You can find the detailed version of Source control by navigating to Help --> About Source Control in SQL Source control tab in SSMS. Also check if any update is available at Help --> Check for Updates?

If you are on the latest version and there are no update to apply try the following steps:

If you have only this single database connected to your repository using Redgate Source control follow below mentioned steps:

1. Unlink the database.

2. Close SSMS

3. Go into %localappdata%\Red Gate\SQL Source Control 34. Delete everything in Transients\ and WorkingBases. Open SSMS

6. Relink the database.

If you have multiple databases connected to your repository using Redgate Source control follow below mentioned steps:

1. Right-click on the 'Linked to' path in SSMS

2. Select "show working base" that'll open the right folder in explorer

3. Unlink the database.

4. Close SSMS

5. Delete everything in Transients\ and WorkingBases\ sub-folders opened by SOC when you followed step 2. You need to look for any other unwanted folders created by SOC (make sure they are related to that database) and delete them as well

6. Open SSMS

7. Relink the database.

Let me know how you get on with it.

Could not find a part of the path

p_dadey — Tue, 23 Apr 2013 05:48:56 GMT

Hi

I am getting the following error when trying to Commit Changes or Get Latest from SQL Source Control:
"Could not find a part of the path 'C:\Users\xxxxxx\AppData\Local\Red Gate\SQL Source Control 3\Transients\0yq4kpdk.ml3\Stored Procedures\dbo.usp_xxxxxx.sql'"

However I am able to open the file from that location and commit it to Subversion.

I'm not able to use SQL Source Control until I am able to rectify this issue.
Any help would be appreciated.

Cheers

RE: regexp_split_rows in sql toolkit?

james.billings — Fri, 02 Mar 2012 12:02:35 GMT

Your question doesn't sound really like it's a question on our toolkit - you couldn't "replace a db" with our toolkit.

If you do need assistance, please clarify exactly what problem you're having, ideally with sample code - but it sounds like you're using a different product.

regexp_split_rows in sql toolkit?

card123 — Thu, 01 Mar 2012 09:51:26 GMT

Hi,

In SQL_XML db, UDFs were using NzLua functions and now we have replaced the db with Sql toolkit extension, Is there an equivalent of regexp_split_rows function in the extension tool kit, there is something called array_split but i think it is not similar in function to regexp_split_rows. Please advise.

Auto Dealer Advertising

RE: sample VB.NET code for sql data compare with backups

elizas — Wed, 17 Mar 2010 10:25:57 GMT

Using the SQL SMO object we can easily take backup of SQL database through code.

http://www.mindfiresolutions.com/Backup-SQL-Database-Through-Code-In-VBNET-846.php

RE: Getting "Invalid object name" error during Schema Comparison

Brian Donahue — Wed, 22 Jul 2009 10:00:58 GMT

Hi,

I think that SQL Compare updates views that are dependent on tables that are being updated as well. Have you got a view named wallMainCondition, and if so, can you try dropping and recreating it? It seems like a compiled version of the view is incorrect or something wierd like that.

RE: Getting "Invalid object name" error during Schema Comparison

Chadwick00008 — Tue, 21 Jul 2009 18:06:08 GMT

Ok, I tried it with the DisableAndReenableDdlTriggers option and got the same result.

When I run the SQL script in 2005 Im getting this error:

Msg 208, Level 16, State 1, Procedure sp_refreshview, Line 1
Invalid object name 'MSS.dbo.wallMainCondition'.

I can't find the SP sp_refreshview in the database...even in the system SP's.

RE: Getting "Invalid object name" error during Schema Comparison

Brian Donahue — Tue, 21 Jul 2009 17:00:11 GMT

There is an option to disable ddl triggers: DisableAndReenableDdlTriggers
You can use this option wherever you can specify Options, for instance in the Work.BuildFromDifferences method.

RE: Getting "Invalid object name" error during Schema Comparison

Chadwick00008 — Tue, 21 Jul 2009 16:41:20 GMT

I took the SQL script output and tried running it directly in MSSQL 2005. It came back with the error:

Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'MSS'.

As far as I know, there are no stored procedures in the database. Any thoughts?

RE: Getting "Invalid object name" error during Schema Comparison

Chadwick00008 — Tue, 21 Jul 2009 14:34:19 GMT

Thanks for the prompt reply. : )

If it is a DDL trigger, is there some way I can tell the toolkit to ignore it, or to not append it when running the script?

RE: Getting "Invalid object name" error during Schema Comparison

Brian Donahue — Tue, 21 Jul 2009 10:00:58 GMT

Hi Chad,

I can't say where this object name is coming from without knowing your database schema. If it doesn't appear in the actual update script, then I'd assume you have got a DDL trigger somewhere running this code as a result of your attempted schema modification.

Getting "Invalid object name" error during Schema Comparison

Chadwick00008 — Fri, 17 Jul 2009 22:30:29 GMT

Hello,

I've got some code to synch the schemas of two databases. When I run it, I get an exception during the .ExecuteBlock function that comes back with "Invalid Object Name 'MSS.dbo.wallMainCondition'". I've looked through both databases (which I ran through the SchemaCompare tool from RedGate) and the tables exist in both databases.

The two databases are currently both residing on my machine as Im testing out the code for a client. Im not sure where/why it is appending MSS to the front of dbo.wallMainCondition, as the word MSS appears no where in the resulting script. Below is the code fragment and resulting script produced.

Thanks in advance,

Chadwick

****************CODE FRAGMENT**************************
// Now generate a differences object to hold differences between
// the two database schemas.
Differences differences = db1.CompareWith(db2, Options.Default);
foreach (Difference difference in differences)
{
if (difference.DatabaseObjectType == ObjectType.User || difference.DatabaseObjectType == ObjectType.Schema)
{
difference.Selected = false;
}
else
{
difference.Selected = true;
}
}

// Create the SQL execution script to run on the TB if any differences are found
ExecutionBlock blockSchema = null;
try
{
if (differences.Count > 0)
{
Work work = new Work();
work.BuildFromDifferences(differences, Options.Default | Options.IgnoreUsers | Options.IgnoreUserProperties | Options.IgnoreOwners, true);
blockSchema = work.ExecutionBlock;

/// DEBUG:
FileInfo tDiff = new FileInfo("SchemaDifferences.txt");
StreamWriter TexSchema = tDiff.CreateText();
TexSchema.WriteLine(blockSchema.GetString());
TexSchema.Write(TexSchema.NewLine);
TexSchema.Close();
///

BlockExecutor executorSchema = new BlockExecutor();
executorSchema.ExecuteBlock(blockSchema, strServerTB, strDatabaseTB);
}
}
catch (Exception exc)
{
m_bLoggedIn = false;
string strMsg = "Error executing SQL statement block during schema compare: " + exc.Message.ToString();
MessageBox.Show(strMsg, "Error");
}
finally
{
blockSchema.Dispose();
db1.Dispose();
db2.Dispose();
}
*******************END CODE FRAGMENT********************

*******************SQL OUTPUT FILE************************
/*
Script created by SQL Compare version 5.3.0.44 from Red Gate Software Ltd at 7/17/2009 5:25:34 PM
Run this script on TRANS-CHADLAPTO.MSS_TB to make it the same as TRANS-CHADLAPTO.MSS_CENTRAL
Please back up your database before running this script
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO
PRINT N'Altering [dbo].[WallDefects]'
GO
ALTER TABLE [dbo].[WallDefects] ALTER COLUMN [Description1] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
exec sp_refreshview N'[dbo].[CGALL_TABLES]'
exec sp_refreshview N'[dbo].[CGCOLUMN_PRIVILEGES]'
exec sp_refreshview N'[dbo].[CGTABLE_NOPRIVILEGES]'
exec sp_refreshview N'[dbo].[CGTABLE_PRIVILEGES]'
exec sp_refreshview N'[dbo].[mapxqz61606482]'
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT>0 BEGIN
PRINT 'The database update succeeded'
COMMIT TRANSACTION
END
ELSE PRINT 'The database update failed'
GO
DROP TABLE #tmpErrors
GO

RE: Column-level control over comparison SQL

Brian Donahue — Fri, 10 Jul 2009 16:40:39 GMT

I have written some sample code for the SDK wiki that will comment out all column drops from the SQL Compare SQL scripts. I hope you all find this useful!!

http://78.31.104.66/index.php/Filter_migration_script

RE: Column-level control over comparison SQL

cleek — Fri, 06 Feb 2009 21:23:58 GMT

What I really need is the ability to ensure that no column in the target database is dropped.

RE: Column-level control over comparison SQL

cleek — Fri, 30 Jan 2009 17:28:58 GMT

Having the ability to control the schema comparison script at a column level is something that we would really like to have. Please consider this a feature request.