yeah... just looking to see if there was any light at the end of the tunnel or if the light was an oncoming train.

:sick:

yeah,

Right now we basically do the following for any change.

1. Script out the base table schema with the change.

2. run a power shell script that re-scripts out copies of...

a.thomson2 (9/16/2008)

---

Sounds Painfull... I'm guessing you could do using the master tables but there would be quite a complex update code to run. Are you wanting to add the same...

:crazy:

wonderful... was really hoping we wouldn't need to hire a "schema guy".

I did not get a chance to try this today but I will be giving it a whirl first thing tomorrow and post back success or Fail.

Thanks for the...

yep I am testing it in a dev environment right now and so far it looks like the new table forces a new snapshot to be created and that then...

Oberion (8/20/2008)

---

if repl is already setup, u can add a new table if you like via the gui or syntax. Since you are asking, you should do it via...

True, but I forgot to add that by virtue of qa testing the application data will change and snapshots are readonly.

I am trying to explain that the complexity...

cant easily do snapshots or copies as the data size of some of ourt dbs are over 300GB. with 1000's of Id's we would need 3 or 4 levels...

I have the director of QA asking for this "golden copy" of data that they wish to test against and then revert back after testing.

is this a possibility ...

I have a similar situation but it has another layer of complexity... any thoughts on how to refresh QA data with the following:

each QA person need a specific login ID...

yup I have confirmed we are seeing a IO performance hit.

disk read time on our D drive ( where the data files are) is very high and also accounts...