Monday, March 19, 2012

Import Database

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.

No comments:

Post a Comment