Red Gate forums :: View topic - Error while running migration script, Invalid object in MV2
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Error while running migration script, Invalid object in MV2

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
joseph.tg



Joined: 30 May 2013
Posts: 11

PostPosted: Mon Mar 17, 2014 2:09 pm    Post subject: Error while running migration script, Invalid object in MV2 Reply with quote

Hi Team,
I am facing and issue in Red Gate Source Control beta

My source control version is Red Gate Source Control 3.9.6.67 (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'.

Thanks,
Joseph
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Thu May 15, 2014 3:34 pm    Post subject: Reply with quote

Hi Joseph,

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group