Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how to move database changes from one location to another

0 views
Skip to first unread message

Les Caudle

unread,
Jan 5, 1997, 3:00:00 AM1/5/97
to

I'm new to SQL Server 6.5.

With Access, I would add fields to my copy of the database, then take
the empty database to the customers's site and use INSERT INTO queries
to bring in all the customer's data into the new database. The
auto-incrementing primary keys (identity) would be imported without
change.

As long as processed the tables in the proper order and didn't remove
a field, it would work.

Is there a way to do the same thing with SQL 6.5?
--
Thanks in advance, Les Caudle <lca...@worldnet.att.net>

Avnet CMG

unread,
Jan 8, 1997, 3:00:00 AM1/8/97
to

The most common way to do this ( table structure changes ), is to write an
SQL script to perform the structure changes, then run the script against
your customer's tables. If you have further questions, please feel free to
email me.

Michael

Les Caudle <lca...@worldnet.att.net> wrote in article
<32d0dbb4...@netnews.worldnet.att.net>...

Mark Eaton

unread,
Jan 13, 1997, 3:00:00 AM1/13/97
to

Actually, there are some modern database modeling tools (like ERWin)
which will actually generate the script given two different versions of
your schema.

Mark

--
Mark W. Eaton
Director, Product Development
Advent Software, Inc.
301 Brannan Street
4th Floor
San Francisco, CA 94107
Phone: (415) 543-7698 x428
FAX: (415) 896-1327
Internet: mea...@advent.com

0 new messages