DatabaseMigrator reruns whole commands always


Author
Message
Luiz Lima
Luiz Lima
StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)StrataFrame User (214 reputation)
Group: Forum Members
Posts: 66, Visits: 724
Hi,

I´m using DatabaseMigrator to deploy DB changes to a lot customers databases in the same server.
The problem is:
All commands are processed every time that I run the program, but I realized that it rans the same command already proccessed before like:

• 12/03/2010 09:56:02 -> The relationship 'FK_tb_ped_compra_tb_item_pec' was created successfully.
• 12/03/2010 09:56:09 -> The relationship 'FK_tb_tit_pag_tb_tit_pag_ccusto' was created successfully.
• 12/03/2010 09:56:09 -> The relationship 'FK_tb_tit_pag_tb_tit_pag_proj' was created successfully.
• 12/03/2010 09:52:50 -> The table 'tb_tit_rec' was successfully altered.

Other thing:

• 12/03/2010 09:52:42 -> The relationship 'FK_tb_tit_rec_tb_tit_rec_ccusto' was successfully dropped.

If DatabaseMigrator drop my FKs, what is happen if I run it over a DB with real data?

Tks guys

Reply
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Thanks for your input Luiz.  The DDT is a very complex tool and does a lot.  Providing the ability to avoid scripts as well as move from version 1 to 10 in a single step requires some testing and configurations.  However, I do receive your input and one of the things high on our list is a new version of the DDT.  I agree that there are times when speed is an absolute.  I am not sure why it is taking 3 minutes as our medical app has over 200 tables, hundreds of sprocs, dozens of views, CLR assemblies, and plenty of UDFs and it doesn't take 3 minutes (unless running in a porr environment which can happen from time to time).  All of that being said, there is always room for improvement and learning from current versions...that is why there is always a next version! Smile  Thanks for your business and input.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search