Is there a way to back up the design changes in a SQL Server database
without backing up all the data? It's just test data at this point. 9 1596
The way I usually do it is to use the scripting feature in Enterprise Manager.
This will generate SQL scripts that can be run on a new database to rebuild
the database structure.
On 4 Jan 2005 11:38:05 -0800, "Jerry Porter" <je****@persona blepc.com> wrote: Is there a way to back up the design changes in a SQL Server database without backing up all the data? It's just test data at this point.
There are some thrid party tools like RegGate Compare that will push
just the changes and keep the data intact...!
Right click on the db --> all tasks --> generate SQL script. You can
script the whole db, you can do that before and after changes to keep
track of versions. You can create a job to do it to.
TGru
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Thanks Steve,
I had used that tool, but hadn't taken it all the way.
[Right-click on database, All Tasks, Generate SQL Script, Show All,
Script all objects]
I don't suppose there's a way to automate this?
On 4 Jan 2005 12:19:21 -0800, "Jerry Porter" <je****@persona blepc.com> wrote: Thanks Steve,
I had used that tool, but hadn't taken it all the way. [Right-click on database, All Tasks, Generate SQL Script, Show All, Script all objects]
I don't suppose there's a way to automate this?
Unfortunately, it seems not. Most other database servers make this a feature
of the database server itself, not the GUI tool, but this is Microsoft we're
talking about.
Rightclick and generating script will give you scripts but when you run
them in production environment, it will drop tables and recreate
them... You still need to figure out a way to save the data.... So I
wouldnt recomend that unless, you just wanted to keep a log of changes
made to the DB....!
As far as I know, there are no direct way to do this unless you go for
some thrid party tool....
I found some old threads suggesting the use of SQL-DMO to generate
scripts, so I looked into it. The following VBA code generates a text
file with scripts for all (?) database objects:
Dim srv As SQLDMO.SQLServe r2
Dim db As SQLDMO.Database 2
Dim tr As SQLDMO.Transfer 2
Set srv = New SQLDMO.SQLServe r2
srv.Connect "MyServer", "sa", ""
Set db = srv.Databases(" MyDatabase")
Set tr = New SQLDMO.Transfer 2
With tr
..CopyAllObject s = True
..DestDatabase = "test"
End With
db.ScriptTransf er tr, SQLDMOXfrFile_D efault _
Or SQLDMOXfrFile_S ingleSummaryFil e, _
"c:\temp\dbscri pt.txt"
Set tr = Nothing
Set db = Nothing
Set srv = Nothing
There are at least 3 scripting methods (Script, GenerateSQL,
ScriptTransfer) , and a long list of options, so there's a good change I
don't have it exactly right.
Jerry This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: mark |
last post by:
Hi
I'm hoping that some could point me in the right direction for "best
practice" in:
1) securely backing up a complete sql7 and 2000 server containing many
databases.
2) backing up an individual database
|
by: kneejerkreaction |
last post by:
I have a couple of general questions:
(1) Are many companies really developing OO systems, and if so, who does the OO analysis, i.e. the design of classes, is this typically done by the developers or by some king of OO analysis specialists. Is a company wide data model needed or can systems be developed independently with each system having its own classes etc? I can't see this company ever agreeing on a centralized data model as there are so...
|
by: J. Frank Parnell |
last post by:
hello, i dont know asp at all, but i have been asked to backup a database
that is used on a site which uses .aspx.
i dont need to do anything with it, just copy it and send it along to
someone who will. I have the IP, username, password.
i have allready got all the files off the site with ftp, is the database in
there? i dont really even know what i'm looking for, but i dont see any .mdb
or .sql right off the bat.
|
by: Jerry Porter |
last post by:
Is there a way to back up the design changes in a SQL Server database
without backing up all the data? It's just test data at this point.
|
by: Stewart Allen |
last post by:
Hi
Just asking for ideas on table design.
The design I have is as follows:
*tblBuildData*
BuildID (PK) AutoNumber
ManufactureDate
SerialNumber
| |
by: manning_news |
last post by:
Using A2K. Last year, a design master for a customer was developed and
placed it in their folder on the network which I do not have rights to.
I found a replica on my PC that I would like to convert to a design
master so that I can make changes to the tables per the customer's
request. If I choose Tools..Replication..Recover Design Master, it
recognizes that the design master is in the customer's folder. Access
Help says I should sync...
|
by: rdemyan via AccessMonster.com |
last post by:
I have code in my front end that opens a form for backing up the front end.
I'll give a brief description of what the form does:
1) When the backup form opens, it closes all open forms except for three
hidden forms and the backup form itself.
2) It automatically creates a backup name for the front end and displays the
folder where it will be backed up.
3) The user clicks the backup button and the following code executes:
|
by: YellowFin Announcements |
last post by:
Introduction
Usability and relevance have been identified as the major factors
preventing mass adoption of
Business Intelligence applications. What we have today are traditional
BI tools that don't work
nearly as well as they should, even for analysts and power users. The
reason they haven't
reached the masses is because most of the tools are so difficult to use
and reveal so little
|
by: jim |
last post by:
I'd like to get some .net sample code that shows me how to make a complete
backup of a hard drive (like my C: drive) to another location (say my D:
drive) while the C: drive is in use.
Basically, I'd like to make and give away free backup software because
Acronis has given me so many problems.
Any help or links you could provide would be greatly appreciated. (Please
include your name to be added to the credits screen in the free...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |