Packagin SQL Server 2000 databse

Hot Topic

Is support available for Visual Basic 2005 Express Edition?
BindingSource.Find by operator LIKE
Getpixel API
Can't register for activation key for Visual Web Developer 2005 Express Edition Beta
issue regarding registration for express edition in img format
Validate Text in a Textbox
vbKeyEscape
Visual C++ 2005 Beta 2 breaks when trying to view project options
Creating a Database in Visual C++
TextBoxes accept 'Returns' even if 'AcceptsReturns' is False!

VS Express Editions

Database problems: Save data, Change table definition
How can I prevent the first picture from disappearing?
Put data from form into table
Building mixed mode apps
vs_setup.ms_ not 'expanded'. - VBasic Express
Where's the Quickwatch window
some VB 2005 express problems
shutdown command
I need to count by ascii characters. Seems tricky!
storing multiple iso files on DVD - Sessions?

Packagin SQL Server 2000 databse

Can Some one please tell me the tool to package my SQL Server databse. I want to deploy it some where else. I have just seen SQL Packager(Third party) I believe Microsoft has a tool.




Answer this question

Packagin SQL Server 2000 databse

  • Atanas - AQA

    I'm not aware of a Microsoft tool.  How you do this will depend on what you mean by "deply someplace else".  If you mean you just want to deploy the basic structure of the database so someone else can use you application for their own data then the easiest thing is usually to use Enterprise Manager to generate scripts for your objects and then apply those scripts to the other database using osql or some similar tool.  If you want the data included, then using backup and restore might be the easiest way to do it.  There is also a copy database wizard available.  You might also just detach the database, copy the files to the other machine and then attach them there.
  • Packagin SQL Server 2000 databse
Answer this question