r****z 发帖数: 4 | 1 我需要自动存所有的SQL SERVER TABLES DAILY because users need to run queries
to compare the data changes for any specified periods. I plan to use SSIS
and ask SQL Server ADMNIN to set up scheduler to run it automatically. I
only have 2 days to complete it including weekends. I have never used SSIS
before. Is there a quick way to learn it? It seems it is hard to learn it
quickly. BTW, I use sql server management studio
Thanks! |
s*****w 发帖数: 215 | 2 SSIS is mostly click and drag, so not difficult to learn.
You need to have visual studio to do design and import the dtsx file to the
sql server management studio for scheduling the job.
queries
【在 r****z 的大作中提到】 : 我需要自动存所有的SQL SERVER TABLES DAILY because users need to run queries : to compare the data changes for any specified periods. I plan to use SSIS : and ask SQL Server ADMNIN to set up scheduler to run it automatically. I : only have 2 days to complete it including weekends. I have never used SSIS : before. Is there a quick way to learn it? It seems it is hard to learn it : quickly. BTW, I use sql server management studio : Thanks!
|
a*******t 发帖数: 891 | 3 you mean you need the table schema saved daily?
you can run a job with SQL command to query the Infornation_schema views and
save it to your history table
don't need SSIS for this ba
queries
【在 r****z 的大作中提到】 : 我需要自动存所有的SQL SERVER TABLES DAILY because users need to run queries : to compare the data changes for any specified periods. I plan to use SSIS : and ask SQL Server ADMNIN to set up scheduler to run it automatically. I : only have 2 days to complete it including weekends. I have never used SSIS : before. Is there a quick way to learn it? It seems it is hard to learn it : quickly. BTW, I use sql server management studio : Thanks!
|
b******g 发帖数: 81 | 4 看你的帖子是要比较数据,可以做一个自动备份的Job,将数据库备份,然后恢复到不
同的数据库进行比较。
Job 里的Step1 写如下内容:
=======================================
USE master
GO
DECLARE @DATESTR VARCHAR(50),@FILESTR VARCHAR(200)
SET @DATESTR=CONVERT(VARCHAR(50), GETDATE(),120)
SET @DATESTR=REPLACE(@DATESTR,':','') |