Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old October 24th, 2006, 03:55 PM
kmurlikrishna kmurlikrishna is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2006
Posts: 17 kmurlikrishna User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 57 m 17 sec
Reputation Power: 0
SQL Server 2000 to 2005 Data Migration

1) We have OLTP DB on 2000 & OLAP DB on 2005.

2) We have decided to use SSIS for migration and interface is BIDS to develop, build, deploy & install SSIS packages.

3) Initial full migration is simple with column mapping and queries.

4) Incremental nightly scheduled migration is based on datetime value of source table column versus datetime value of end of most recent migration.

5) Inserts, updates and deletes are allowed in source. Whatever is updated and deleted in source I am finding the PK's via query compare via linked server in stored proc & deleting all these records from target all this in stored proc.

6) Now I have to pass these PK's along with inserted PK's to select statement of SSIS package against source to insert into target.

7) We even have to encrypt some tables colmns data while reading from source so that it is secure in network and gets into target database as such requiring decryption for reports and front end display.

8) Is my approach okay? How do I pass the PK's to SSIS package SQL statement. How, where and when do I fit in encryption part.

9) Are there any better ways that you can think of.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > SQL Server 2000 to 2005 Data Migration


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT