ps_vbdev (1/13/2015)

---

Ok so your doing the comparison in your staging area. but you would still have to do a full extract from source db (bulk Insert?) to get the source...

How I typically do this is that I keep a copy of the three source tables in a staging area. Meaning, I read from the source tables using CDC and...

My first thought is using an indexed view and putting CDC on that, but I'm not sure that is possible. I'm asking around if this is feasible.

khushbu (1/13/2015)

---

even the renaming will not be allowed since SP are dependent.

We are looking at any Third party tool since the code will eventually promote to Production environment where its...

khushbu (1/13/2015)

---

When I try to drop old column it passes an error of dependent Stored procedure.

I can drop the index and recreate them however I do not want to the...

I don't immediately see issues with your plan.

Are there any views on the table?

The query plans for the stored procedures will most likely be recompiled on their next execution.

CDC needs to be enabled on the source database and on the individual tables. You then have the query some functions (created by CDC) to get the changed data.

If you...

You can also set TypeGuessRows to 0 in the registry. It then scans the first 60,000 rows or so.

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1650619-391-1.aspx

What is the original data type and what is the new data type?

Easy one, thanks.

Now that you are here: the mustard is excellent 😉

Very interesting question, thanks.

Great question, thanks.

Easy one, thanks Steve.