backing up tables

Can anyone tell me how I can backup / restore individual tables?
At the moment I have been backing up the msde database on the development
machine and restoring it onto the web server in order to transfer data.
But I have now reached the point where the data on the web server no longer
matches the data on the development machine. The data on the web server is
good but I have some structural changes to some tables on the development
machine.
Is there a method by which I can update only some of the tables on my web
server?
To date I have been using DBAMGR2K for all data manipulation.
Suggestions would be most appreciated.
Neme
If you want to make schema changes to the tables, you can create a script to
alter the table and add columns etc. You can either do this manually (see
ALTER TABLE in Books Online) or use a tool to generate the scripts for you,
for example SQLCompare from www.red-gate.com.
Jacco Schalkwijk
SQL Server MVP
"June Macleod" <junework@.hotmail.com> wrote in message
news:e7UZhiXzEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Can anyone tell me how I can backup / restore individual tables?
> At the moment I have been backing up the msde database on the development
> machine and restoring it onto the web server in order to transfer data.
> But I have now reached the point where the data on the web server no
> longer
> matches the data on the development machine. The data on the web server
> is
> good but I have some structural changes to some tables on the development
> machine.
> Is there a method by which I can update only some of the tables on my web
> server?
> To date I have been using DBAMGR2K for all data manipulation.
> Suggestions would be most appreciated.
> Neme
>