update test data to the live data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 28 Jul 2008 16:06 GMT

I created a SQL server 05 test database. Now I'd like to update its data to
the live database. Can you please show me how to do that?
Thank you for your help in advance.

Reply to this Message

Rick Sawtell - 28 Jul 2008 16:09 GMT

>I created a SQL server 05 test database. Now I'd like to update its data to
> the live database. Can you please show me how to do that?
> Thank you for your help in advance.

What do you mean by update it's data to the live database?

Are you talking about migrating schema changes, permissions and other
security items, or the actual data stored in the tables?

Rick Sawtell

Reply to this Message

Tom Moreau - 28 Jul 2008 16:09 GMT

Your problem statement is rather vague. If you want a complete copy of
prod, then back it up and restore onto the test server. However, if you
want something more specific, you'll have to clarify.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

I created a SQL server 05 test database. Now I'd like to update its data to
the live database. Can you please show me how to do that?
Thank you for your help in advance.

Reply to this Message

Tom Moreau - 28 Jul 2008 16:10 GMT

Answered in .programming. Please don't multi-post.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

I created a SQL server 05 test database. Now I'd like to update its data to
the live database. Can you please show me how to do that?
Thank you for your help in advance.

Reply to this Message

Tom Moreau - 28 Jul 2008 16:12 GMT

Oops, my mistake. :-(

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

Answered in .programming. Please don't multi-post.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

I created a SQL server 05 test database. Now I'd like to update its data to
the live database. Can you please show me how to do that?
Thank you for your help in advance.

Reply to this Message

Tim - 28 Jul 2008 20:32 GMT

A test SQL database was created for a couple months ago by making a copy from
the live db. However, now the live db has new data input by users. Therefore,
the test db need to up-to-date with the live data. How can I update the test
db? Hope you understand I am trying to do.
Thanks

> Oops, my mistake. :-(
>
[quoted text clipped - 3 lines]
> the live database. Can you please show me how to do that?
> Thank you for your help in advance.

Reply to this Message