StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Controlling column order

Controlling column order

Keith Chisarik — Tue, 06 Oct 2009 11:11:02 GMT

How does one control the column order when maintaining fields in the DDT? Ideally the column order that ends up in SQL should match the order displayed in the DDT. It does not, additionally I have an occurrance where the column order is different when deployed to two different SQL servers even after the tables on both servers have been dropped. This is wreaking havoc with some import functions I have.

RE: Controlling column order

Edhy Rijo — Tue, 06 Oct 2009 11:11:02 GMT

[quote][b]Keith Chisarik (10/06/2009)[/b][hr]I want the tool to do this for me, ideally.[/quote]

Me too. :P

RE: Controlling column order

Keith Chisarik — Tue, 06 Oct 2009 10:53:08 GMT

I want the tool to do this for me, ideally. Ill try your idea if Trent doent come up with something. I think the DDT should do this, perhaps it does I just dont know of a secret setting or trick (I hope).

RE: Controlling column order

Edhy Rijo — Tue, 06 Oct 2009 10:34:41 GMT

Anyway, here is sample of the generated script in which it will rename, create new structure with fields in order then copy data back to new table, and delete renamed table.

RE: Controlling column order

Edhy Rijo — Tue, 06 Oct 2009 10:23:25 GMT

Hi Keith,

I think it is a problem with MS-SQL. Using other tools to design the tables, I have noticed that in order to keep the columns in the same order as I design them, it will have to rename the table, create a new one with the current field order, then copy the data from the renamed table, and then delete the renamed table.

If you want I can send you a copy of the script that is being generated for this "Copy" functionality.

RE: Controlling column order

Keith Chisarik — Tue, 06 Oct 2009 10:08:08 GMT

sorry but...bump