Post reply

Copy DB from Express to SQL Server?

  • April 17, 2007 at 7:35 pm

    #177702

    Can I copy a DB (structure, data, keys, relationships) that I create in Express to a regular SQL Server?  If so, whats the best way to do this?

  • April 18, 2007 at 7:58 pm

    #701307

    The best is backup and restore, if both are in the same network just register one with the other, if not put the .bak in the backup sub folder under Microsoft SQL Server.  Then go to Management Studio and use the backup and restore wizard and choose restore from device.  Post again if you still need help.  Hope this helps.

     

    Kind regards,
    Gift Peddie

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

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