Hello All-
I am trying to copy a database with all data (SQL Server) from one PC to another PC.Could anybody tell me how can I do this. Remember there is no connection between two PC.
SOhel
Printable View
Hello All-
I am trying to copy a database with all data (SQL Server) from one PC to another PC.Could anybody tell me how can I do this. Remember there is no connection between two PC.
SOhel
Well, first of all, the best thing to use, depending on the system and hardware you have, to use a tape cartridge. In SQL 6.5, what you can do is this:
on the first pc, run a full db dump backup of the database locally to your tape backup or any large capacity disk storage (zip). Make sure that both PCs have same hardware.
on second pc, take the backup you made and restore it to the new pc. That will restore everything: stored procedures, tables, etc.
hope this helps.
PS-Both PCs must have the same SQL for this to work.