6 Comments

  • Book name? Publisher? Author? Should I have to go looking through the pdf to find this? Didn't they teach you to quote your sources in school? Naughty. No cookie for you.

  • Maybe I missed something, but I don't see how you make a create script that reconstructs the data as well as the schema.



    I can see how to export the database structure, but there doesn't seem to be any option for exporting data in the create scripts. I only see the "Export Data..." menu option, which (a) is seperate from create scripts and (b) appears only to be available one table at a time.

  • Ian - you have to export data 1 table at a time because it exports to a file that is then used by the SQL Server bcp utility to import the data. But once you have exported the data, you can create command scripts that will create the database, create the schema, and import the data.

  • Hi,

    I have a table (with the same name) on 2 different machines.

    lets call the machines:

    1) machineToOverwrite

    2) machineToBeOverwritten



    So, I want to OVERWRITE thae table on machineToBeOverwritten, with the table contained in machineToOverwrite.



    I right-click my table --> export data --> OK

    The table.dat file appears in the system explorer, in the "CreateScripts" folder.



    I am unable to add this .dat file to a command file.

    How do I overwrite the table on machineToBeOverwritten with this .dat file?

    Do I have to manually write a bcp script, or does vis studio do this for me?

    I'm on vis studio 2003 Enterrprise.



    Many thanks.

    yogi

  • Hi,

    Got it.It was staring me in the face.



    yogi

  • Do you have any idea how this can be done in VS2005?

Comments have been disabled for this content.