A new topic, 'known bugs/limitations for mssql server ', has been made on a
board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=55.new#new
The text of the topic is shown below:
Just completed exporting our existing database to a liquibase changeset! Great
tool!
However, after generating the changelog I used SQL Delta to compare the new
database generated by liquibase with our existing pristine database and
discovered a number of limitations with generateChagneLog which made the
conversion a bit time consuming. I thought I would share what I found so that
they can be addressed in future releases. Our current database is MS SQL 2005.
1) length of nvarchar columns are lost
2) nvarchar(max)/varchar(max) is converted to ntext/text
3) missing the ability to set the identity seed value on for auto increment
column
4) missing option to make primary key non-clustered
5) missing ability to create defaults, on those columns where defaults were
used it would generate the create default statement in default value which
doesn't work
6) missing ability to include non-key columns on create index
(http://msdn.microsoft.com/en-us/library/ms190806.aspx)
7) missing create statistics
8) missing column documentation (sp_addextendedproperty)
9) several indexes were not generated, but many were. I think most of them
were those with non-key columns but some of those that were generated had
non-key columns and I had to replace the create index with raw sql so I'm not
sure why some were generated and others not.
10) several foreign keys constraints were not generated, but many were, not
really sure why. I find that on a few tables the same foreign key constraint
was defined twice but with different names.
11) missing check constraints
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
