Hi,
I have the following simple situtation:
I created my database (just tables) in Server1, then made a copy to Server2.
There, i changed all the datatypes and created relationships
between the tables.
Now, I want to transfer, not update, completely replace, all the previous
versions of tables from Server1 with the new DB.
I want to ask before i do something stupid.
- Will DTS delete and replace all previous-version tables and add the new
relationships automatically?
- How about all these system tables that are generated automatically
(sysfiles, sysdepends, etc.) ? Do I have to replace them too?
Thanx in advance,
I know its simple but i am very afraid to screw up my DB during the copy.
-steveBackup the database on the "good" server, transfer the backup to the "bad"
server, and restore this
backup over the database on the "bad" server.
Refer to BACKUP DATABASE & RESTORE in BOL
"steve" <steve@.here.com> wrote in message
news:tR3je.15721$JU3.69048@.wagner.videotron.net...
> Hi,
> I have the following simple situtation:
> I created my database (just tables) in Server1, then made a copy to
Server2.
> There, i changed all the datatypes and created relationships
> between the tables.
> Now, I want to transfer, not update, completely replace, all the previous
> versions of tables from Server1 with the new DB.
> I want to ask before i do something stupid.
> - Will DTS delete and replace all previous-version tables and add the new
> relationships automatically?
> - How about all these system tables that are generated automatically
> (sysfiles, sysdepends, etc.) ? Do I have to replace them too?
> Thanx in advance,
> I know its simple but i am very afraid to screw up my DB during the copy.
> -steve
>|||"steve" wrote:
> I have the following simple situtation:
By far the easiest way to do this is to "move" the actual physical data
files. Doing this is easy with attach/detatch. See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
Maury|||"steve" <steve@.here.com> wrote in message
news:tR3je.15721$JU3.69048@.wagner.videotron.net...
> Hi,
> I have the following simple situtation:
> I created my database (just tables) in Server1, then made a copy to
> Server2. There, i changed all the datatypes and created relationships
> between the tables.
> Now, I want to transfer, not update, completely replace, all the previous
> versions of tables from Server1 with the new DB.
> I want to ask before i do something stupid.
> - Will DTS delete and replace all previous-version tables and add the new
> relationships automatically?
> - How about all these system tables that are generated automatically
> (sysfiles, sysdepends, etc.) ? Do I have to replace them too?
> Thanx in advance,
> I know its simple but i am very afraid to screw up my DB during the copy.
> -steve
>
If you can overwrite the database on Server1, then backup and restore is
probably the easiest solution - I don't really understand from your comments
if that is an option for you or not.
If not, then you could use DTS, or script the objects you want to change
from Enterprise Manager, then run the scripts on the target server. If you
need to keep existing data, and modify tables in place, then you'll need to
write your own ALTER scripts. You shouldn't try to modify or copy system
tables - it isn't necessary.
Whatever you decide, you should probably put some effort into putting your
object scripts in a source control system, setting up a clear release/change
management process etc. You can save a lot of time in the long run if you
have the tools and processes to understand exactly what your code is and
where it goes, especially if you may have to support multiple versions of
your application.
Simon
