transfer object including the transfer other associate object
-
I have one database in other SQL server. The people worked there left the company already.I need to find out the ins and out the database. Since I do not want to mess up the current database. I plan to copy the database to my local sql server machine. It will be safer. I did a import. but I know it also a lot DTS package and other thing I do not know. How can I get all the information import to my locate server that ?
By the way, It gave me error while I import the database.
I am new to SQL server.
Thanks.
F
-
Try a backup and restore.
Back up the existing database to disk.
Copy the backup file to your machine, and restore it locally.
You should be able to use Enterprise manager to do this.
F1 for help.
If you get stuck anywhere post another question and will be glad to help
-
but I think back up did not give me the DTS pacage, the connection.
-
There's a very good chance that, even if you do transfer the DTS packages, they won't work on your PC without being 'tweaked'. For someone who is new to SQL Server, trying to work out the ins and outs of DTS packages is a rude introduction to the subject.
But one way of doing this is to go into Enterprise Manager on the originating machine, edit the DTS package and then select Package / Save As -> you can save to your own SQL Server instance from here.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
Thanks. That is what I need. I need to combine two application together by figuring out how other people accomplish that.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply