Red Gate forums :: View topic - Getting Started - problems with example
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Getting Started - problems with example

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
nhustak



Joined: 09 May 2006
Posts: 34

PostPosted: Sat May 08, 2010 2:11 pm    Post subject: Getting Started - problems with example Reply with quote

Hi All,
Just getting started with the SDK. Used one of the sample to just test registering. I keep getting 'Could not continue scan with NOLOCK due to data movement.' when making the dbTargert.Register call.

Here's the code. It's extremly simple - my intention was to go step by step and test as I went. I've changed all my private info but I have been consistent - it's all on the same server as indicated by the names. The TargetDB is empty.

The SourceDB has data in all tables and is not currently in use, so I'm baffled by the data movement

Code:
   using ( Database dbTarget = new Database(), dbSource = new Database() )
            {
                ConnectionProperties cpSource = new ConnectionProperties( "MyServer", "SourceDB", "AUser", "APassword" );
                ConnectionProperties cpTarget = new ConnectionProperties( "MyServer", "TargetDB", "AUser", "APassword" );

                dbSource.Register( cpSource, Options.Default );

                dbTarget.Register( cpTarget, Options.Default );
            }



Thanks,
Nick H
Back to top
View user's profile Send private message
nhustak



Joined: 09 May 2006
Posts: 34

PostPosted: Sat May 08, 2010 2:17 pm    Post subject: Reply with quote

Ok advanced search turned up some people talking about this (generic search on these forums sucks).

I can verify - there is nothing going on with these databases, especially the target one. I JUST created it. There's no way it's busy or the source database for that matter. These are development databases and have no mainteance plan running on them. This is on one of my personal servers located in my house - no one else is on it.

Nick H
Back to top
View user's profile Send private message
nhustak



Joined: 09 May 2006
Posts: 34

PostPosted: Sat May 08, 2010 2:23 pm    Post subject: Reply with quote

Ok more fun. I reordered the opens to put the target database first.

This is a new database, just created. It HAS no tables besides system. I am still getting the nolock error on it.
Back to top
View user's profile Send private message
nhustak



Joined: 09 May 2006
Posts: 34

PostPosted: Sat May 08, 2010 2:24 pm    Post subject: Reply with quote

I have removed all references to the source database, so the only thing I am trying to register is a blank database.

BTW, SQL Server 2008 Enterprise

Ideas?
Back to top
View user's profile Send private message
nhustak



Joined: 09 May 2006
Posts: 34

PostPosted: Sat May 08, 2010 4:20 pm    Post subject: Reply with quote

Well this error is now appearing in my application..so something going on with my server!
Back to top
View user's profile Send private message
nhustak



Joined: 09 May 2006
Posts: 34

PostPosted: Sun May 09, 2010 4:49 pm    Post subject: Reply with quote

The problem was my sql server. Everything is resolved.
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