Developing apps with sql server tables

microsoft.public.dotnet.languages.vb

1 Sep 2006 12:28 PM

Mrozu

Hi

How do you develop applications with tables in SQL Server? I mean how
do you copy tables to other computers? Do you make it by 'CREATE TABLE'
SQL Query? With big tables (with many columns) this way isn't so good I
think.

Thx Mrozu

1 Sep 2006 2:41 PM

Gultekin Komanli

Mrozu wrote:

> Hi
>
> How do you develop applications with tables in SQL Server? I mean how
> do you copy tables to other computers? Do you make it by 'CREATE
> TABLE' SQL Query? With big tables (with many columns) this way isn't
> so good I think.
>
> Thx Mrozu

Well, if you mean copying data to other servers (such as test server,
development server etc) you can use DTS ( data transformation services)
for copying data.

Another way is taking backups and restoring on the other machine.