Red Gate forums :: View topic - Correct ordering of DB objects in synchronization script
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Correct ordering of DB objects in synchronization script

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dariasbrownCJ



Joined: 27 Mar 2014
Posts: 2

PostPosted: Thu Mar 27, 2014 6:11 pm    Post subject: Correct ordering of DB objects in synchronization script Reply with quote

Does SQL Compare 9 or 10 Standard support the following:

Dependency checking so objects are scripted in the correct order for updates. Database objects are scripted in the correct order even if SQL metadata (sysdepends) is broken.

Thanks,

Darias
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Mon Mar 31, 2014 2:36 pm    Post subject: Reply with quote

Hi Darias,

SQL Compare has had its' own text-parsing dependency engine since about version 3, so you should be pretty safe with dependencies, even if sysdepends has a problem. It needs this parsing support in order to work with scripts as a data source, so it's reliable.

When comparing a live database, v10 uses sysdepends as a starting point and then adjusts depending on the definition of the objects in the database.
Back to top
View user's profile Send private message
dariasbrownCJ



Joined: 27 Mar 2014
Posts: 2

PostPosted: Wed Apr 02, 2014 8:35 pm    Post subject: RE:Correct ordering of DB objects in synchronization script Reply with quote

Brian,

Thanks for your response. I have an issue with the SQL Compare parser because it has been creating objects that depend on tables ahead of the table DDL.

Darias
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Thu Apr 03, 2014 8:45 am    Post subject: Reply with quote

If there is a problem with this then there is probably some defect in that version. Is it possible to upgrade to v10? We don't provide support for prior versions but we can fix it if there is a problem with the current version.
Back to top
View user's profile Send private message
SPeacock1978



Joined: 16 May 2014
Posts: 1

PostPosted: Fri May 16, 2014 2:11 pm    Post subject: Reply with quote

I am having a similar problem. I have a table that has a full text index on it and there is a stored procedure that uses this functionality. When I use SQL Compare 10 to create a deployment script the scripts creates the objects in the following order:

1) Create table
2) Create indexes
3) Create stored proc
4) Create full text index on table

As the full text index does not exist at the time the stored proc is being created I get the following error...

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblCompany' because it is not full-text indexed.

Is there a way to control the ordering of the objects in the scripts or is it all automatic?
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 528
Location: Red Gate Software

PostPosted: Tue May 20, 2014 1:12 pm    Post subject: Reply with quote

That one's a particularly persistent bug caused by a compromise solution to the problem that full text operations interact poorly with transactions - it's on the list of issues we're actively looking at, but currently the workaround is to do two deployments - first with the fulltext objects and second with the procedures that depend on them.

We hope to have this fixed for v11.
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