Compare tables layout in dev and prod

Hi,
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-Chen
Hi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen
|||Thank you very much!
"Hari Prasad" wrote:

> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
>
>

Compare tables layout in dev and prod

Hi,
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-ChenHi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen|||Thank you very much!
"Hari Prasad" wrote:
> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> > Hi,
> >
> > Does anyone know that without the tool, how to compare table's layout
> > those
> > are existing development and production servers?
> >
> > Regards,
> > -Chen
>
>

Compare tables layout in dev and prod

Hi,
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-ChenHi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen|||Thank you very much!
"Hari Prasad" wrote:

> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a tab
le
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
>
>

Compare csv file layout to SQL Server table

I am creating a facility whereby you can select a source file (.csv), and a target (SQL table).

Then I call a DTS to copy the csv file to the SQL table.

How can I validate that the two files have the same number of columns ?

Moved to SQL Server Tools forum|||In order to check the number of rows you need to work on DTS with workflow, refer to books online for more information and you can schedule the DTS package a SQLagent job by right-click on selected package.|||I need to validate that the correct file has been selected before scheduling the DTS package. This is why I need to do it in my VB.Net Windows application.|||

You can write a custom Script Task inside the SSIS package that will open the file and check how many columns it has. You can utilize Excel object model for that or just go with regular .NET IO libraries.

Hope that helps.

Maciek Sarnowicz

Compare csv file layout to SQL Server table

I am creating a facility whereby you can select a source file (.csv), and a target (SQL table).

Then I call a DTS to copy the csv file to the SQL table.

How can I validate that the two files have the same number of columns ?

Moved to SQL Server Tools forum|||In order to check the number of rows you need to work on DTS with workflow, refer to books online for more information and you can schedule the DTS package a SQLagent job by right-click on selected package.|||I need to validate that the correct file has been selected before scheduling the DTS package. This is why I need to do it in my VB.Net Windows application.|||

You can write a custom Script Task inside the SSIS package that will open the file and check how many columns it has. You can utilize Excel object model for that or just go with regular .NET IO libraries.

Hope that helps.

Maciek Sarnowicz