November 18, 2008 at 7:11 am
We are working on Analytics daily refresh automation. In this process, taking backup of Star Schema is one of the major tasks. One of the option for the backup that we have thought of is as mentioned below, wherein we will require your help to carry out a POC.
1. We will maintain a backup database which will hold Star Schema and transaction table. This backup database will be on different MSSQL instance.
2. Before modifying existing data, we will take backup (copy data) of Start schema / transaction tables on backup database which even should be retrievable in case of issues.
In oracle, copying of tables across instances is achieved using DB links. We need your help here:
a. To check whether same DB link concept is available on MSSQL or not.
b. If yes, how much time it will take to copy tables across instances.
November 18, 2008 at 10:52 am
Hi,
Answers inline.
a. To check whether same DB link concept is available on MSSQL or not.
Yes. In SQL Server we have the concept of "Linked Servers" with which you can set up a link to any OLEDB datasource.
b. If yes, how much time it will take to copy tables across instances.
That, of course, depends on how much data, your hardware and what technique you will be using to copy the data.
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 18, 2008 at 11:53 pm
How to use Linked server if I want to copy one table from one server schema to another schema on another server ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply