Streaming SQL table data to secondary location
-
Hi there, I want a way to stream data from one table in one database to the same table on a different machine. Is there a way? Any help would be much appreciated. Kind regards, Hugo
-
Hi there, I want a way to stream data from one table in one database to the same table on a different machine. Is there a way? Any help would be much appreciated. Kind regards, Hugo
Option 1: replication Option 2: write a job to perform the bulk transfer.
-
Hi there, I want a way to stream data from one table in one database to the same table on a different machine. Is there a way? Any help would be much appreciated. Kind regards, Hugo
If you don't need to do this in real-time, then you could consider taking a nightly backup of Server A and performing a restore on Server B. Just a thought.
-
Hi there, I want a way to stream data from one table in one database to the same table on a different machine. Is there a way? Any help would be much appreciated. Kind regards, Hugo
If you are using Sql Server 2005 or later, you can use Service Broker.
-
Hi there, I want a way to stream data from one table in one database to the same table on a different machine. Is there a way? Any help would be much appreciated. Kind regards, Hugo
bonkers123 wrote:
Is there a way?
Multiple, and their applicability depends on the type of database that you're using. SQL Server for example has the option to "link" to another database. It also depends a bit on what you expect from the target-table. Does it have to be "up to date" at all times, or would it be sufficient to have access to yesterday's data? To add to the pile of options; you could also use the Microsoft Synchronization Framework.
I are Troll :suss:
-
bonkers123 wrote:
Is there a way?
Multiple, and their applicability depends on the type of database that you're using. SQL Server for example has the option to "link" to another database. It also depends a bit on what you expect from the target-table. Does it have to be "up to date" at all times, or would it be sufficient to have access to yesterday's data? To add to the pile of options; you could also use the Microsoft Synchronization Framework.
I are Troll :suss:
It has to be up to date at ALL times... It's a sql database...
-
bonkers123 wrote:
Is there a way?
Multiple, and their applicability depends on the type of database that you're using. SQL Server for example has the option to "link" to another database. It also depends a bit on what you expect from the target-table. Does it have to be "up to date" at all times, or would it be sufficient to have access to yesterday's data? To add to the pile of options; you could also use the Microsoft Synchronization Framework.
I are Troll :suss:
So how do I link a table of one db, to a the same table on a different db ... ?
-
So how do I link a table of one db, to a the same table on a different db ... ?
From the Management Studio, expand "Server Objects", right-click on "Linked Servers" and select "New Linked Server". There's several options to specify the credentials for the remote database. E.g., if you have Server A (with a master database) and a Server B (with AdventureWorks), then you could execute queries like this;
SELECT [name]
FROM [master].[sys].[tables]UNION ALL
SELECT CAST([VersionDate] AS VARCHAR(50))
FROM [ServerB].[AdventureWorks].[dbo].[AWBuildVersion]More information on configuring a linked server can be found here. Hope this helps :)
I are Troll :suss:
-
From the Management Studio, expand "Server Objects", right-click on "Linked Servers" and select "New Linked Server". There's several options to specify the credentials for the remote database. E.g., if you have Server A (with a master database) and a Server B (with AdventureWorks), then you could execute queries like this;
SELECT [name]
FROM [master].[sys].[tables]UNION ALL
SELECT CAST([VersionDate] AS VARCHAR(50))
FROM [ServerB].[AdventureWorks].[dbo].[AWBuildVersion]More information on configuring a linked server can be found here. Hope this helps :)
I are Troll :suss:
This help ! Thanks !!!!