Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Exporting yourdatabase to SQLServer commands

    I know in MySQL there is a mechanism to export your database to a collection of DDL and DML SQL commands. IS this available in SqlServer?

    Thanks.

  2. #2
    Join Date
    Nov 2003
    Posts
    167
    I just used it this weekend to back-convert a sql08R2 back to sql05. Remember to select "schema and data" in the options if you want the data inserted as well as the objects. Also - if you're back-converting you'll have to remove the statement for the varbinary procedure.


    How To Convert SQL Server 2008 Database To SQL Server 2005?
    Kit Lemmonds

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •