Hot Port Database with my application.

  • Hi there!

    Didn't really know where to place this post, so i am putting it in General.

    I ran into a problem. I have an application build using SQL Server 2K, and has quite a data. now, I have to port this application to testers, who are not located in the office and would require access to database.

    can someone please show me the correct way to perform the following during application installation:

    1. Create Database (have scripts already);

    2. Port data into tables. (no clue at all)

    may be there are some applications or setup tools, which can perform these functions.

    Please point me in right direction.

    P.S. -> HOT is really How TO. sorry for mistype.


    CodeGuru - C/C++/C# related programming Forums
    Sql Server Central - Sql server Related Forums.

  • How large is your data? Either backup/restore and sp_detach_db/ sp_attach_db work. See BOL for details.

  • for testing, i just have to provide sought of Sample Data.

    I have 15 tables, I think 10 records per table would be pretty enough.

    Will sure take a look at BOL. thanks for reply Allen.

    aren't there any Setup and deployment application for Databases? same as you have one for application,


    CodeGuru - C/C++/C# related programming Forums
    Sql Server Central - Sql server Related Forums.

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

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