backing up tables -- sql server msde

June Macleod
11/18/2004 2:15:33 PM

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

Jacco Schalkwijk
11/18/2004 2:38:58 PM

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

[quoted text, click to view]

sql server msde : backing up tables