November 2, 2007 at 3:23 am
Dear all,
I'd like to load/transfer data FROM the Test db TO the Production db (the same table).
In Oracle dbases this can be done via dblinks. Is it possible to SQL Server 2005 ?
Thanks
------------------------
------------------------
November 2, 2007 at 4:05 am
open 2 instances of sql...
1) Test db.
2) Production db.
If u hav database publishing wizard, then point the connection string to testdb & relevant database.
That will run a script with both schema & data.
Then, point to production db.
open the query analyzer.....> Run the testdb script here.
NOW, U WILL HAVE THE TEST DB VALUES INTO PRODUCTION DB.
if u dont hav DBP wizard, then download the same microsoft,... its freely available.
November 2, 2007 at 5:00 am
Read up on OPENQUERY + LINKEDSERVERS IN SQL SERVER 2005. This basically allows you add linked database which you can manipulate in SQL SERVER.
The great thing about it is that it is not restricted to SQL Server database you can create links to Oracle, Progress etc. You can even perform joins between different linked servers.
it is pretty simple to set up
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply