Remote DML/DDL from different Nodes to MS SQL Server 2005
-
Hello. I was tried figuring out how to use my different pc to perform DML/DDL operation in Mircosoft SQL Server and whose effect will be shown in Main PC. There demo is described below. 3 PC. 2 PC = Client for DML/DDL Operation. 1 PC = Server to reflect changes. OS in 3 PCs = XP Pro. All 3 PCs have Sql Server 2005 installed. Now.. what I want to do is .. if I do any DML/DDL operation from those two pcs which acting as a client the changes should affect in the Main Server PC. I m not figuring out the way to LINK those two PC's SQL Server with the Main PC's SQL Server. Please assist me in finding a technique to solve this problem. We already connect these 3 pcs successfully with LAN but not getting a way to solve this problem.
-
Hello. I was tried figuring out how to use my different pc to perform DML/DDL operation in Mircosoft SQL Server and whose effect will be shown in Main PC. There demo is described below. 3 PC. 2 PC = Client for DML/DDL Operation. 1 PC = Server to reflect changes. OS in 3 PCs = XP Pro. All 3 PCs have Sql Server 2005 installed. Now.. what I want to do is .. if I do any DML/DDL operation from those two pcs which acting as a client the changes should affect in the Main Server PC. I m not figuring out the way to LINK those two PC's SQL Server with the Main PC's SQL Server. Please assist me in finding a technique to solve this problem. We already connect these 3 pcs successfully with LAN but not getting a way to solve this problem.
Is the SqlServer on these PCs the Express version?
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
-
Hello. I was tried figuring out how to use my different pc to perform DML/DDL operation in Mircosoft SQL Server and whose effect will be shown in Main PC. There demo is described below. 3 PC. 2 PC = Client for DML/DDL Operation. 1 PC = Server to reflect changes. OS in 3 PCs = XP Pro. All 3 PCs have Sql Server 2005 installed. Now.. what I want to do is .. if I do any DML/DDL operation from those two pcs which acting as a client the changes should affect in the Main Server PC. I m not figuring out the way to LINK those two PC's SQL Server with the Main PC's SQL Server. Please assist me in finding a technique to solve this problem. We already connect these 3 pcs successfully with LAN but not getting a way to solve this problem.
This sounds weird and not very good. Do you want all 3 servers to reflect the changes made in 1? There is not way that I know of to do this 'on the fly', you can use something like Red-Gate SQL Compare and data compare to synchronise the structure but this is a seperate operation, it generates a script that could be run on each server. Backup/Restore will include the data (obviously)
Never underestimate the power of human stupidity RAH
-
This sounds weird and not very good. Do you want all 3 servers to reflect the changes made in 1? There is not way that I know of to do this 'on the fly', you can use something like Red-Gate SQL Compare and data compare to synchronise the structure but this is a seperate operation, it generates a script that could be run on each server. Backup/Restore will include the data (obviously)
Never underestimate the power of human stupidity RAH
I have Developer Edition of SQL Server. What actually will happen is 2 data entry operators will enter datas from 2 pcs and the changes should be made in the database reside in my Server PC. It doesn't matter for me if those 2 pcs are having SQL Server installed. My main concern if DML/DDL from 2 pc should affect Server PC.
-
I have Developer Edition of SQL Server. What actually will happen is 2 data entry operators will enter datas from 2 pcs and the changes should be made in the database reside in my Server PC. It doesn't matter for me if those 2 pcs are having SQL Server installed. My main concern if DML/DDL from 2 pc should affect Server PC.
What is the client the DE users are using?
Never underestimate the power of human stupidity RAH
-
What is the client the DE users are using?
Never underestimate the power of human stupidity RAH
Sorry I didn't get you mate. All PCs have Developer Edition [DE]. And application are made by me and my friends. Suppose when I open SQL Server 2005 and Run the Insert Query on a table then that insert should ALSO reflect in SERVER. We don't care if that Data will store in Client side too.
-
Sorry I didn't get you mate. All PCs have Developer Edition [DE]. And application are made by me and my friends. Suppose when I open SQL Server 2005 and Run the Insert Query on a table then that insert should ALSO reflect in SERVER. We don't care if that Data will store in Client side too.
Because this is such a broad issue I have posted a link to a resource that might help you out. Replication[^]
“If you think you are worth what you know, you are very wrong. Your knowledge today does not have much value beyond a couple of years. Your value is what you can learn and how easily you can adapt to the changes this profession brings so often.”-– Jose M. Aguilar
-
Sorry I didn't get you mate. All PCs have Developer Edition [DE]. And application are made by me and my friends. Suppose when I open SQL Server 2005 and Run the Insert Query on a table then that insert should ALSO reflect in SERVER. We don't care if that Data will store in Client side too.
I think your issues may be that you are using SQL Server as a client type tool. Normal design is a database server (sql server) and a client tool (winforms or web form). The client tool resides on the PCs and connect to the server. You seem to have 3 servers and the are using servers as clients. Thats why you are having trouble getting a sensible response. Nobody in their right minds would build such a solution. Go back to start and design your solution properly, build the client in C#/VB and have them connect to the server.
Never underestimate the power of human stupidity RAH
-
Because this is such a broad issue I have posted a link to a resource that might help you out. Replication[^]
“If you think you are worth what you know, you are very wrong. Your knowledge today does not have much value beyond a couple of years. Your value is what you can learn and how easily you can adapt to the changes this profession brings so often.”-– Jose M. Aguilar
Thanks.. Sorry to say from my above post regarding this
Suppose when I open SQL Server 2005 and Run the Insert Query on a table then that insert should ALSO reflect in SERVER. We don't care if that Data will store in Client side tooThis will provide inconsistency if 1 client is used to re-enter the data already entered by other client. So I think, continuous Synchronization should be there between databases as soon as any DDL/DML operation will done. How to achieve this ? -
Thanks.. Sorry to say from my above post regarding this
Suppose when I open SQL Server 2005 and Run the Insert Query on a table then that insert should ALSO reflect in SERVER. We don't care if that Data will store in Client side tooThis will provide inconsistency if 1 client is used to re-enter the data already entered by other client. So I think, continuous Synchronization should be there between databases as soon as any DDL/DML operation will done. How to achieve this ?nt_virus wrote:
So I think, continuous Synchronization should be there between databases as soon as any DDL/DML operation will done. How to achieve this ?
It's obvious you think you know the answer already. Let us know how that works for you.
“If you think you are worth what you know, you are very wrong. Your knowledge today does not have much value beyond a couple of years. Your value is what you can learn and how easily you can adapt to the changes this profession brings so often.”-– Jose M. Aguilar