New Topic: known bugs/limitations for mssql server

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
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user