CODEWITHSUNDEEP
sql-server
coure2011
coure2011

Reputation: 42444

Copy data from local to production

I have 2 copies of database, one on local PC other on production server (web site). I insert data into my local copy. How can I upload the newly inserted data (in local-copy) to production server?

Upvotes: 1

Views: 149

Answers (3)

abatishchev
abatishchev

Reputation: 100258

You can create an incremental backup and restore it on prod.

Or use Import/Export Wizard if you can gather the new data using several queries.

Upvotes: 0

Ron Potato
Ron Potato

Reputation: 11

Add the other machine as a "Linked Server" under "Server Objects".

Then access it like:

SELECT * FROM ServerPotato.DB_AWE.dbo.potato_prices

which is:

<Linked Server>.<Database>.<Schema Owner>.<Table>

The schema dbo is probably necessary, where normally you may write: DB_AWE..potato_prices

Upvotes: 0

D&#39;Arcy Rittich
D&#39;Arcy Rittich

Reputation: 171411

I recommend you generate insert scripts and then run them on the prod server.

There are many tools to do this: a popular one is RedGate SQL Data Compare.

Upvotes: 2

Related Questions