Hi all,:confused:
I doing some Online projects...
for that some time i want to import database from online database server(located in Newyork), some time i want to transfer datatabse from one server to another server.
At this time i was used DTS Import/Export wizard, but i am not able to copy the relatioships of the tables(Primary key,foreign key,defaults,views,storedprocedures,triggers).
My query is How i downlod a database with exact structure and all data as it as in remote server.
thanks in advansecan't u use Backup & restore
:)|||thanks for ur rply,,
then how can i import online database to local..with databse structure and data.|||You copy the .bak file from the remote server to the local server and then do a restore.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment