A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.
Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith
I am facing and issue in Red Gate Source Control beta
My source control version is Red Gate Source Control 220.127.116.11 (migration V2 beta version)
I have a table called 'CustomMigration' in a database and the database is already source controlled.
I am trying to add a migration script for inserting the data into 'CustomMigration' table
migration script is:
insert into CustomMigration(Id) values(12345)
Added this migration script and executed using F5 button and clicked on save and close button.
Clicked on commit changes tab, getting below error
Error while running migration script:
Invalid object name 'CustomMigration'.
- Posts: 11
- Joined: Thu May 30, 2013 7:53 am
I noticed you never got an answer here, sorry! It looks like that ought to work - have you tried using the multi part identifier for the table name instead, like [dbo].[CustomMigration]? I've tested this a couple of different ways (with/without multi part identifiers and guard clauses) here and they all seemed to work, but it's worth a try.
Andy Campbell Smith
Red Gate Technical Support Engineer
- Posts: 173
- Joined: Thu Oct 20, 2011 11:19 am
- Location: Red Gate Software
Return to SQL Source Control 3
Who is online
Users browsing this forum: No registered users and 1 guest