Copying sql server data to local sql express db

[sanjaysk]

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?

 

[Stephen]

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?

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.