Results 1 to 5 of 5

Thread: create script

  1. 06-28-2005, 03:15 AM #1
    hajee
    hajee is offline Registered User
    Join Date
    Jun 2005
    Posts
    3

    create script

    hi,

    I gotta get my website online and since I can't connect to the host their SQL server I have to export the data in another way.
    I'm realy no SQL-server expert so I am asking, is there a way to generate a script with the initial data?
    I allready gave them a script to create the tables, stored procedures, views and stuff.

    some additional info.... I use SQL server 2000 and they use sql server 7.

    thanks.........

    H.J.
    Reply With Quote Reply With Quote
  2. 06-28-2005, 08:48 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Why don't ask them backup the db for you and ftp the backup file to you?
    Reply With Quote Reply With Quote
  3. 06-30-2005, 02:02 AM #3
    hajee
    hajee is offline Registered User
    Join Date
    Jun 2005
    Posts
    3
    wel I gotta get the data to them. and since they have SQL server 7 it isn't possible to restore a back-up made in sql-server 2000
    Reply With Quote Reply With Quote
  4. 06-30-2005, 02:47 AM #4
    Rawhide's Avatar
    Rawhide
    Rawhide is offline Registered User
    Join Date
    Feb 2003
    Posts
    1,048
    You can use Generate SQL Script to script the whole database and every object in it. Then you can DTS the data out to text files.
    Reply With Quote Reply With Quote
  5. 06-30-2005, 06:34 AM #5
    hajee
    hajee is offline Registered User
    Join Date
    Jun 2005
    Posts
    3
    thanks, very helpfull.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules