Re: Tracking changes in mssqld db

From: Tascien (tascienu_at_ecoaches.com)
Date: 11/28/04 

Date: 28 Nov 2004 08:34:49 -0800

Thanks for your answer but, these tools are often over priced for such
an easy task. $499 US. seem a little bit too much to me...

What i want to know, is, if MSSQL has a built in log that keeps track
of structure changes within databases. Because i am sure, every time i
change a database using ms access, it sends a SQL query to the server.
I want to know if the server then keeps tracks of all those queries,
if so, where can i find that log, so that i can clean it, and run in
on the production once i am done making changes to the dev server.

sounds like a simple thing to do, but i am not sure where to find the
answer...

Thanks for your suggestion again.

Tascien

GYK <GYK@discussions.microsoft.com> wrote in message news:<D2E38B49-B03B-464E-9305-432BCD8C4DFD@microsoft.com>...
> If you want a easy way, there are some third party s/w available, one of them
> being Reg-Gate SQL Bundle. This can be used to get the difference between two
> databases across the servers. And it also synchronizes the data structure
> between your development and production database.
>
> HTH
> GYK
>
> "Tascien" wrote:
>
> > I am using MSSQL 2000 and Microsoft Access Database Project (.adp) to
> > manage my database...
> >
> > how can i track the changes made to the sql database structure when i
> > make changes to tables through msaccess ui?
> >
> > the reason i am asking this, is because i have built my website on the
> > production server, and i am continuing to do some changes on the
> > development server. Once i am done on the dev server, I will put my
> > files on the production. But then, I don't want to overwrite the
> > production. what i want to do when i move my files, is just to modify
> > the production database to map to my changes on the dev and therefore
> > keep the data that is already in.
> >
> > any suggestion would be appreciated.
> >
> > Tascien
> >

Relevant Pages

  • RE: help with emergency--sql server 2000 sp4
    ... I told my myself, I need to take a look at my testing database, I suddenly I ... some my production program gives invalid object error messge. ... We have two database instances on our server. ... Your ASP program failed to execute DML operations on your SQL Server after ...
    (microsoft.public.sqlserver.odbc)
  • MOSS 2007 Database Migration from Test to Production
    ... sql server to a production sql server in a MOSS 2007 environment. ... configuration database on the wrong server. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: What is your database application development environment?
    ... development, then switch to the Test or QA database for optimization, ... both our Dev and QA processes used smaller databases. ... have DEV boxes or CPU cycles that closely resemble QA and production. ... each running SQL Server Developer. ...
    (borland.public.delphi.non-technical)
  • Re: Ideal Web Development Environment?
    ... only developer in a 1 server department with no budget, few resources, ... having to make structural changes to a live database), ... Config Files: There have to be many types of config files. ... One for the production server. ...
    (comp.lang.php)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
Loading