Copying sql server data to local sql express db

Discussion in 'Database Support' started by sanjaysk, Feb 4, 2009.

  1. sanjaysk

    sanjaysk Perch

    I know the extract database method to generate sql insert statements and then use them to transfer data from remote to local and from local to remote. But is there a quicker way? For example, the special jodohost database backup works quite fast to store a local .BAK file. But how can I use that .bak file to restore the db to my local database?
  2. Stephen

    Stephen US Operations Staff Member

    You can do a restore using most SQL managment tools as the BAK is standardized format. You may have to work on user permissions when done.

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services