how to call database stored in a file to update the other database on SQL Server

[Sally1053]

My task is to take a database from one machine(X)and put into my machine(Y), maybe in a file or XML and retrive data from it to insert or upate the database on my machine(Y), This databases must use or have same names.

So my problem is how do I show the path on my procedure to call that database from the file or implement it in XML ?



Please if anyone knows help out because my boss need this as yersterday

[davef]

My task is to take a database from one machine(X)and put into my machine(Y), maybe in a file or XML and retrive data from it to insert or upate the database on my machine(Y), This databases must use or have same names.

So my problem is how do I show the path on my procedure to call that database from the file or implement it in XML ?



Please if anyone knows help out because my boss need this as yersterday

Create a new empty database on your computer. Backup the database on the box x and copy that backup file over to your computer. Restore the database from the backup file on your machine using the new empty database.

[balajiu]

You can update your database with the database files in two ways.

1.Attach database
2.Restore database

You can use restore method to restore database backup file( dbbackup.bak) in you system.

.Restore Method.

1.Open Enterprise manager window.
1. Create an empty database(name should be same as name of the database do you want to restore in your machine).
2.Right click an newly created database ,select 'restore database' from 'all tasks'.
3. Check with 'From Device' radio button and browse for the backup file . (Eg: C:\backup.bak) and complete the dialog.
4.Check 'force restore over existing database' checkbox in Options tab and then click ok.
Now you can see that transaction dialog box is begining to update database in your system.