export/import database only using osql

  • I want to export the entire database and create a new database using the export using osql.

    I'm running SQL Desktop edition (2000)

    How can I do it? Any possible problems I may encounter? Does the imported database contain the user permissions or should I have to run a script to create user permissions?

  • There are a few options that you could use in order to do this even with OSQL but if it were me, I would just do a backup and restore with osql. That seems like the simplest way to handle that sort of thing and you just use the regular backup and restore commands you would use if you were going through QA/SSMS.

    It is possible that in the restore process that some users will get orphaned, but if that happens it is typically a simple thing to resolve. I did a quick google search and this article tells you how to resolve it quite nicely.

    http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm

    There are many ways but this would probably be my choice if I were tied to OSQL.

  • You can detach the db from source and attach on the destination server.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply