Red Gate forums :: View topic - FILLFACTOR = 90 added to table scripts
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

FILLFACTOR = 90 added to table scripts

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



Joined: 29 Mar 2011
Posts: 3
Location: merriam,ks

PostPosted: Sun Nov 18, 2012 5:14 am    Post subject: FILLFACTOR = 90 added to table scripts Reply with quote

When I run SQL Compare from command line with /scriptfile option to DB it adds FILLFACTOR=90 to every table then I have to undo changes because those aren't in source control of the linked DB that I have.

This comes up often because I delete my db, restore a backup to do some troubleshooting, then use sqlcompare to reload it without unlinking or re-linking. It's a time saver for me because for some reason it takes 10minutes to link our database and it only takes me a few seconds to regenerate the DB from SQL Compare.

This is mostly just a nuisance that I have to go undo changes to get back to work.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
stanori



Joined: 23 Apr 2012
Posts: 76

PostPosted: Tue Nov 20, 2012 6:53 pm    Post subject: Reply with quote

Hi jpeckham,

Thanks for your forum post. In regards to the fill factor setting, by default the command line doesnt set this option. You can try adding the following option to your command line to set the "Ignore Fill Factor setting":

/options:IgnoreFillFactor

Best Regards,
Steve
_________________
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
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