newbie question

Hi,
i've just finished MOC 2779B and i would like to play with the "monster"...
at work we have 2 MS SQL server 2005 RDBMS installed on 2 PCs.
let's say that DB-PC1 is the source DB where a certain application runs
on PC1.
DB-PC2 is a test DB on PC2.
I would like to do the following things :
1- create a view on DB-PC1 to retrieve only the necessary data for DB-PC2.
2- everytime this data view is updated (deleted, inserted or updated
records) i would like to send the complete vdata view to DB-PC2 (test DB)
3- in this test DB, everytime that it receives data from DB-PC1, it
should split data records (fields, ...) into several parts and insert
them into tables availables on DB-PC2.
Like that we totally split data and risks to damage them.
I want to do that because i'm preparing a web portal on test DB-PC2
which should use a partial data information from DB-PC1.
So i do not want this web portal (in case of mistake into code) to
destroy partially DB-PC1.
so i though that for point 1 i could create a view and triggers to
detects update, inserts or delete actions.
However, how can i send this information (data view) from DB-PC1 tp DB-PC2 ?
Do you have any suggestion ?
thanks a lot,
R.A.F.You want me to send my resume' where? What your asking for is not a
small task and is probably out of scope for one posting. Try breaking
your project above down in to individual tasks, do your homework
first, and then post if you can't find the answer.
If you are the one that's going to be doing this...I would start with
Linked Servers and go from there. Also, in my opinion, wipe Views
complete from your chain of thought. Think Stored Procedures!
You have one nice project in front of you! Good Luck!
On Dec 1, 4:34 am, "R.A.F." <noem...@.nospam.com> wrote:
> Hi,
> i've just finished MOC 2779B and i would like to play with the "monster"..
.
> at work we have 2 MS SQL server 2005 RDBMS installed on 2 PCs.
> let's say that DB-PC1 is the source DB where a certain application runs
> on PC1.
> DB-PC2 is a test DB on PC2.
> I would like to do the following things :
> 1- create a view on DB-PC1 to retrieve only the necessary data for DB-PC2.
> 2- everytime this data view is updated (deleted, inserted or updated
> records) i would like to send the complete vdata view to DB-PC2 (test DB)
> 3- in this test DB, everytime that it receives data from DB-PC1, it
> should split data records (fields, ...) into several parts and insert
> them into tables availables on DB-PC2.
> Like that we totally split data and risks to damage them.
> I want to do that because i'm preparing a web portal on test DB-PC2
> which should use a partial data information from DB-PC1.
> So i do not want this web portal (in case of mistake into code) to
> destroy partially DB-PC1.
> so i though that for point 1 i could create a view and triggers to
> detects update, inserts or delete actions.
> However, how can i send this information (data view) from DB-PC1 tp DB-PC2
?
> Do you have any suggestion ?
> thanks a lot,
> R.A.F.|||thanks Dave.
this is the kind of help i needed : linked servers.
how ? :-)
are there some requirements, or suggestions from MS ?
Dave wrote:
> You want me to send my resume' where? What your asking for is not a
> small task and is probably out of scope for one posting. Try breaking
> your project above down in to individual tasks, do your homework
> first, and then post if you can't find the answer.
> If you are the one that's going to be doing this...I would start with
> Linked Servers and go from there. Also, in my opinion, wipe Views
> complete from your chain of thought. Think Stored Procedures!
> You have one nice project in front of you! Good Luck!
>
>
> On Dec 1, 4:34 am, "R.A.F." <noem...@.nospam.com> wrote:
>|||SQL Server 2005 Books Online (September 2007)
Linking Servers:
http://msdn2.microsoft.com/en-us/library/ms188279.aspx
Ekrem nsoy
"R.A.F." <noemail@.nospam.com> wrote in message
news:OQncU$FNIHA.5360@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> thanks Dave.
> this is the kind of help i needed : linked servers.
> how ? :-)
> are there some requirements, or suggestions from MS ?
> Dave wrote: