November 11, 2010 at 11:13 pm
Hi
sql 2005
I have to take a Backup of a table from prod instance and restore the same in Reporting instance.
this process should be automated, kindly tell me the beset way of doing .
Note:- SSIS is not recommended in our organization, please dont suggest that. Suggest me some best solution.
November 11, 2010 at 11:59 pm
hemadribabu (11/11/2010)
Hisql 2005
I have to take a Backup of a table from prod instance and restore the same in Reporting instance.
this process should be automated, kindly tell me the beset way of doing .
Note:- SSIS is not recommended in our organization, please dont suggest that. Suggest me some best solution.
How many tables you want to move.
What is the build for the two instance.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 12, 2010 at 12:18 am
Have you considered using SQLServer Replication?
Vishal Gajjar
http://SqlAndMe.com
November 12, 2010 at 1:50 am
I have to move 1 table , its size is 700 MB, the movement should take place from production to reporting server, on daily basis. I need this to be automated , so that i can get the values there in production to reporting .
Reporting is a good solution , but is that the only solution to do this? else is there any other meathod to do .
November 12, 2010 at 1:57 am
well, you can also create a new file group on production database which will contain only one table,
then, you can perform a file group backup from production server,
and a file group restore to your reporting server.,
you can find more details on BOL.
Vishal Gajjar
http://SqlAndMe.com
November 12, 2010 at 1:57 am
hemadribabu (11/12/2010)
I have to move 1 table , its size is 700 MB, the movement should take place from production to reporting server, on daily basis. I need this to be automated , so that i can get the values there in production to reporting .Reporting is a good solution , but is that the only solution to do this? else is there any other meathod to do .
Daily its one time purpose.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 12, 2010 at 4:30 am
Yes daily its 1 time purpose
November 12, 2010 at 5:12 am
hemadribabu (11/12/2010)
Yes daily its 1 time purpose
If its one table , Then write a script and automate it.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 12, 2010 at 5:54 am
hemadribabu (11/11/2010)
Hisql 2005
I have to take a Backup of a table from prod instance and restore the same in Reporting instance.
this process should be automated, kindly tell me the beset way of doing .
Note:- SSIS is not recommended in our organization, please dont suggest that. Suggest me some best solution.
On Production write a job that BCP outs the data of the table. Keep that file on a shared folder accessible by report server.
On Report server write a job that truncates the table and loads the file(BCP IN) from the shared folder.
November 12, 2010 at 8:12 am
Replication is a good option. Another option is use a linked server
truncate table ServerB.DatabaseB..TableB
insert into ServerB.DatabaseB..TableB
select * from DatabaseA..tableA
Why is SSIS not recommended at your company ?
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply