How to reproduce a database 1

[Kendel]

I would like to copy a databse from a server to another server, can someone please show me how?

Many Thanks.

 

[mrdenny]

backup the database and restore it to the new server.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Kendel]

Thanks Denny!

 

[Katy44]

I have always done this by creating a database on the server you want, and then going "Import" ... "all objects".
The only drawback I can see to this is that you don't get all your database settings too. Are there any other major drawbacks with this method? I have always wondered about this.

 

[mrdenny]

When you start doing large databases the import will start to take longer and longer, as it's not a fast method. It also puts much more load on the system as it checks all the keys and relationships.

Backing up and restoring is the most rock solid way of doing this without putting much additional load on the origional server.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Katy44]

Thank you!

 

[mrdenny]

no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)