Copy program with SQL database without data

pts.
Tags:
SQL Server
Hi all, One of our sister offices would like to use our program. I was wondering if there is a way to copy the program and database(without data) to a CD? So we can forward it to them? Thanks alot

Answer Wiki

Thanks. We'll let you know when a new response is added.

It depends on your DBMS and OS. Can you be more specific?

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • PMiller78
    The software will depend on it's licensing and the way it is installed. If it is old software you may just be able to copy the directory (would have to be pretty old for this to work as most companies use an actual installation process now). If you can just copy the files, you also need to create your ODBC connection to SQL on the new machine. (This is under the Control Panel 0n 98 and Administrative Tools on 2000,XP & Vista) As far as the SQL Database, if it is MSSQL you can generate a SQL Script file that will only have the structure of the database. This is only text so it will be very small. There may be jobs that need to be scripted out too. More info from you would be helpful to get this narrowed down to if it is possible and how you could do it. Paul
    0 pointsBadges:
    report
  • Mchin247
    Sorry for bad explanation. We are running Microsoft SQL 2000, and Visual Studio Net 2003 on a Windows 2003 Standard server. Thanks.
    0 pointsBadges:
    report
  • PMiller78
    Is the software written by your programmers? That would be the only reason I could see you mentioning VS.Net. If so, they would have all the info needed to produce a copy of the software for ditribution to a sister site. Then all you need is the SQL Data Structure. Since you have MSSQL 2000 you can just generate a script file to build the database on the machine at the new site. It is really pretty easy once you figure out all the pieces you need.
    0 pointsBadges:
    report
  • Mchin247
    Hi PMiller78: The only problem is that it was out sourced. We had someone create it for us. Can I copy the web folder(in IIS), program folder, and an old backup of the data? Let the people at the off site modify the contents?
    0 pointsBadges:
    report
  • SheldonLinker
    Copying the programs is just a matter of copying them. If they involve DLLs, you'll have to register them, too. To copy the schema, start "SQL Server Management Studio Express", or whatever you have that's closest to that name. Navigate to your database, and right click on it. Choose "Generate scripts..." and get to "Finish". You'll get a script to recreate the database, which you can execute on the other system. --- Sheldon Linker (mailto:sol@linker.com) Linker Systems, Inc. (http://www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
    30 pointsBadges:
    report
  • PMiller78
    Well, Sheldon is partially right... If you are copying the files only, there will most likely be .dll files that are in other directories, like the system32 directory. If so, you will need to figure out what they are and where they are located. If the program is more of a web based program (as you indicated by asking about the files in IIS) you will also need to figure out which files are being used in the Application Pools and in the ISAPI Filters if there are any. As far as the SQL Database file, What Sheldon told you to do is just vague enough to not work. Try This: To Generate the Script File: ------------------------------------------ Open Enterprise Manager Use the tree on the left to locate your server Click the + next to Databases Right Click your database, Goto All Tasks and Select Generate SQL Script On the General Tab: Click Show All (On this screen, since I don't know your software) I would just click Script all objects On the Formatting Tab: Ensure the first 4 boxes are checked. On the Options Tab: Select: Script Database Script database users and database roles Script SQL Server Logins (Windows and SQL Server longins) Script Indexes Script full-text indexes Script triggers Script Primary keys, Foreign keys, defaules, and check constraints. Click Ok Name and Save your file (It will be named 'whatyounamedit'.sql, this is just a .txt file) To Build the database from the Script file: Open Query Analyzer -------------------------------------------- On the first screen (Connect to SQL Server) Make sure your server name is listen in the box Select your Authentication mode Enter your login and password Click Ok Click File then Open Select your Script File Execute the script (F5 or CTL+X or click the green arrow above your script) After you run it, the bottom box should say: The command(s) completed successfully. You may see some errors saying 'Could not add rows to SysDepends' You should still be ok if you get them.
    0 pointsBadges:
    report
  • Mchin247
    Thanks Shelton and PMiller778. What if the server at the other location is installed with the same programs? Would that make a difference? I think they have someone that knows SQL(hopefully).
    0 pointsBadges:
    report
  • PMiller78
    Well... it would seem that half your problem would be nonexistant. The only other thing that would need to be done is to get a database up and running for the software to connect to.
    0 pointsBadges:
    report
  • JohndeCoville
    Check this link out. Yes it copies ALL the data base but has various options that I find interesting: http://blogs.techrepublic.com.com/window-on-windows/?p=454&tag=nl.e138 --John
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following