Get cdc tables in visual studio 2012/2010 database project -


i trying create database project in visual studio 2012/2010 need cdc (change data capture) tables , because lot of views dependent on cdc tables. couldn't find way import cdc schema/tables :(. read in many blogs importing cdc not supported. there work around. please suggest

generally wouldn't want cdc tables created database project, want them created using sys.sp_cdc_enable_table
if allow database project create tables in normal manner cdc tables end existing change data capture wouldn't enabled.

obviously can script calls sys.sp_cdc_enable_table in either pre or post scripts, far can tell neither place ideal.

if put sys.sp_cdc_enable_table calls in pre script changes not original tables exist (on fresh deploy none of them exist), or these original tables change shape part of main deploy occurs after pre run.

if put sys.sp_cdc_enable_table calls in post script, can't have views rely on cdc tables existing deployed part of main database project deployment (not without errors or warnings in db project).

i suggest not having many views, functions or stored procs rely on existence of cdc tables, sounds might late that.
side note: speaking should using cdc.fn_cdc_get_all_changes_ , cdc.fn_cdc_get_net_changes_ functions rather referencing cdc tables directly, see querying change data capture data
however, moves problem along 1 level functions not existing in project.
unfortunately, there doesn't seem way have views without scripting them @ same point script calls sys.sp_cdc_enable_table

(i'm hoping else come along better answer solves problem)


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more