Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am in the process of migrating our client's database to the Azure Cloud SQL Server and setting up data sync etc. All of this is ok, but I need to reduce the amount of time the client's system needs to be down for to complete this process.

I was hoping to be able to set up a process that records all database inserts/updates from the time I create the backup which will be used in to migrate the data to azure, and then replay them on the database once it's in the cloud.

Is there a tool for this? Is SQL Profiler good enough for this?

share|improve this question
    
Which edition of SQL Server, and how many tables are in the database? If you're on Enterprise with not too many tables, CDC might be a good option. –  Jon Seigel Jul 26 '13 at 12:53
    
When you say azure cloud, is it windows sql azure or sql server running on windows virtual server ? That makes a huge difference as the former has some limitations with T-sql. –  Kin Jul 26 '13 at 13:06
    
@JonSeigel 100 or so tables, SQL Server 2008 Enterprise, looking into it thanks. –  Alexandre Stroukov Jul 26 '13 at 13:12
    
@Kin it's Windows SQL Azure –  Alexandre Stroukov Jul 26 '13 at 13:13
add comment

1 Answer

Just to close this off, I found that Red gate Data Compare seems to be a great tool that will allow me to simply compare the two databases and in essence replicate the differences.

share|improve this answer
    
Yep, that works, too, if the database is small enough you can afford to scan both copies of it. I suppose I should have asked about that. Actually now that I think about it, you could use Visual Studio if you have the appropriate licence level for it, which may mean you don't have to buy anything new. –  Jon Seigel Jul 26 '13 at 22:47
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.