best format

Results 1 to 2 of 2

Thread: best format

  1. #1
    Join Date
    Dec 1969

    Default best format

    What is the best file format to export from one SQL Server 2000 database to another. I can&#039;t do the regular connect I need to have it export as a file then load it on another machine. What format give the least trouble .mdb, .cvs... and what issues might come up? <BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: best format

    Depending on the size and amount of data involved I&#039;d probably either a)backup the whole database restore it on the other server and then move the data, or b)make a csv file <BR><BR>whatever you&#039;re comfortable with.

Posting Permissions

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