visual studio 2010 - Is there a way to suppress SQL03006 error in VS2010 database project? -

-

first of all, know error getting can resolved creating reference project (of type database server) , referencing in database project... however, find overkill, small teams there no specific role separation between developers , db admins..but, let's leave discussion time... same goes dacs...can't use dac b/c of limited objects supported...

question now, question is: can (and how), disable sql03006 error when building database project. in case error generated because creating users logins "unresolved"...i think should possible hope, since "know" logins exist on server before deploy script...i don't want maintain database server project can keep refs resolved (i have nothing besides logins @ server level)...

workaround using pre/post deployment scripts, trivial secript working...

workaround issue have comment out user scripts (which use login references) workaround... that, .sqlpermissions bomb out, saying there no referenced users...and have comment permissions out , put them in post deploy scripts... main disadvantage of workaround cannot leverage schema compare fullest extent (you have specify ignore users/logins/permissions)

so again, want 1. maintain db project (no references db server projects) 2. disable/suppress sql03006 error 3. able use schema compare in db project

am asking impossible? :)

cheers

p.s. if aware of better vs2010 database project templates/tools (for sql server 2008 r2) please share...

there 2 workarounds:

1. turn off schema checking (tools > options > database tools > schema compare > sql server 200x, object type tab) user or security related. permanent fix

2. go through schema comparison , mark user or security related skip , generate sql compare script. per schema comparison fix.

it should obvious if already have scripts in project reference logins or roles delete them , won't created.


Comments

Post a Comment

Popular posts from this blog

javascript - Enclosure Memory Copies -

-
function myclass() { //lots , lots of vars , code here. this.bar = function() { //do numerous enclosed myclass vars } this.foo = function() { alert('hello'); //don't enclosed variables. } } each instance of myclass gets own copy of bar , foo, why prototyped methods use less memory. however, know more memory use of inner methods. it seems obvious me (1) below must true. agree? not distinct myclass instances have own distinct copies of bar, must have own distinct copies of myclass enclosure. (or else how bar method keep myclass variables straight on per instance basis?) now (2) question i'm after. since inner foo method doesn't use in myclass enclosure natural qustion is: javascript smart enough not keep myclass enclosure in memory use of foo? this depend entirely on implementation not language. naive implementations keep far more around others. answer true e.g. v8 (chrome's js engine) may not true spider...
Read more

php - Replacing tags in braces, even nested tags, with regex -

-
example preg_replace('/\{[a-za-z.,\(\)0-9]+\}/', 'replaced', 'lorem ipsum dolor sit {tag1({tag2()})}, consectetur adipiscing elit.'); the result: lorem ipsum dolor sit {tag1(replaced)}, consectetur adipiscing elit. question as can see "tag2" has been replaced, want replace "tag1" know how can this? (in cases might this: {tag1({tag2({tag3()})})}) , on.) btw using preg_replace_callback, easier show preg_replace here site can test code: http://www.spaweditor.com/scripts/regex/index.php you need add curly braces character set. here's pattern used: /\{[a-za-z.,\(\)\{\}0-9]+\}/ and here result: "lorem ipsum dolor sit replaced, consectetur adipiscing elit."
Read more