"Ghost" database for testing purposes. Copying all tables, views,

hello.
I have a LIVE database. At the same time i am still working on my app. It's
a .Net application. Now, i need to constantly makes changes in both tables.
Not to the data, but to the design. Some fields might be added, some deleted,
new views, new sp.
My question is... How can i automatically update the Live database with any
change in the development database. I would rather make the changes in the
Live database to assure no data loss occur, but i want those changes to be
"replicated" back to my development. is there any system's stored proc that
would help me do that?
Thank you.Automating it is asking for trouble...in case you get someting wrong.
If you insist, use Red Gate SQL Compare to reveal differences between the
two for you and generate a script to run against the live db AFTER you BACK
IT UP :)
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Jose Fernandez" <Jose Fernandez@.discussions.microsoft.com> wrote in message
news:0997C63F-78D0-4618-8D07-5A9DE461107A@.microsoft.com...
> hello.
> I have a LIVE database. At the same time i am still working on my app.
> It's
> a .Net application. Now, i need to constantly makes changes in both
> tables.
> Not to the data, but to the design. Some fields might be added, some
> deleted,
> new views, new sp.
> My question is... How can i automatically update the Live database with
> any
> change in the development database. I would rather make the changes in the
> Live database to assure no data loss occur, but i want those changes to be
> "replicated" back to my development. is there any system's stored proc
> that
> would help me do that?
> Thank you.|||=?Utf-8?B?Sm9zZSBGZXJuYW5kZXo=?= <Jose
Fernandez@.discussions.microsoft.com> wrote in
news:0997C63F-78D0-4618-8D07-5A9DE461107A@.microsoft.com:
> hello.
> I have a LIVE database. At the same time i am still working on my app.
> My question is... How can i automatically update the Live database
> with any change in the development database. I would rather make the
Ditto. www.red-gate.com. It is awesome in a dev/test/prod environment.
Costs about $400.

"Ghost" database for testing purposes. Copying all tables, views,

hello.
I have a LIVE database. At the same time i am still working on my app. It's
a .Net application. Now, i need to constantly makes changes in both tables.
Not to the data, but to the design. Some fields might be added, some deleted,
new views, new sp.
My question is... How can i automatically update the Live database with any
change in the development database. I would rather make the changes in the
Live database to assure no data loss occur, but i want those changes to be
"replicated" back to my development. is there any system's stored proc that
would help me do that?
Thank you.
Automating it is asking for trouble...in case you get someting wrong.
If you insist, use Red Gate SQL Compare to reveal differences between the
two for you and generate a script to run against the live db AFTER you BACK
IT UP
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Jose Fernandez" <Jose Fernandez@.discussions.microsoft.com> wrote in message
news:0997C63F-78D0-4618-8D07-5A9DE461107A@.microsoft.com...
> hello.
> I have a LIVE database. At the same time i am still working on my app.
> It's
> a .Net application. Now, i need to constantly makes changes in both
> tables.
> Not to the data, but to the design. Some fields might be added, some
> deleted,
> new views, new sp.
> My question is... How can i automatically update the Live database with
> any
> change in the development database. I would rather make the changes in the
> Live database to assure no data loss occur, but i want those changes to be
> "replicated" back to my development. is there any system's stored proc
> that
> would help me do that?
> Thank you.
|||=?Utf-8?B?Sm9zZSBGZXJuYW5kZXo=?= <Jose
Fernandez@.discussions.microsoft.com> wrote in
news:0997C63F-78D0-4618-8D07-5A9DE461107A@.microsoft.com:

> hello.
> I have a LIVE database. At the same time i am still working on my app.
> My question is... How can i automatically update the Live database
> with any change in the development database. I would rather make the
Ditto. www.red-gate.com. It is awesome in a dev/test/prod environment.
Costs about $400.

"Bulk copy insert failed"

I'm copying data from tables in one server to tables in another via DTS.

This package have worked fine before, but now (after having refreshed the database information, and re-selected the tables), I'm getting a SQL-DMO: The Bulk Copy execution failed, without no further details.

When selecting a limited subset of the table, I got no errors.
Might be just one of the tables maybe that's causing the error, but there are so many tables so it takes some time to pinpoint which one.

Any hints?Can you post the actual dts package or be more specific in how the package works ?|||I was just going to delete my posting. It was really simple - a column in a table was defined as varchar(50) in the source database but varchar(20) in the destination. I thought the data would "just" be truncated.
After altering the destination column to 50, the package worked fine.

But, the error message really gave no help at all, and the error message info stored in msdb was just blank.
Is the only way to get a proper error message to do some coding in VBscript?