Connection to client database

[MARELUAD]

How can I make a connection with a master database to a client database in a different domain on a NT4 server.
I want every night to export data from the master to the client database.

Master database domainname: A_server
Client database domainname: B_server
Master databasename = M_Database
Client databasename = C_Database
Master tablename = mastertable
Client tablename = clienttable
Master fieldname = masterfield
Client fieldname = clientfield

 

[JayKusch]

First off when you say "Master" are we speaking of a "primary" database or the true SQL Server System database named Master?

If it is senerio 1 then, get into Enterprise Manager(EM) of the Source connection, being A_server. Drill down to the Database you are wanting to export to the Target server, B_server.

Right mouse click "All Tasks" and then Export data. Pick you Source server as A_server..Click Next..Set you Destination server as B_server..Click Next..Should be at "Copy table(s) and view(s) screen by default..Click Next..Now you can pick all the tables you want to export from A_server to B_Server.

Pick the tables you want to export click next and you are presented the screen that says "Run Now" by default. At the bottom of the screen you want to check the "Create DTS Package" so that you can save it. If you are read to run it go ahead.

Now to schedule a job to run at a specified time, go into the "Data Transformation Services" tab of EM and then under "Local Packages". You should see a new package you just created by using the Export wizard. Right click on that package and "Schedule" it.

Now if you were trying to export "specific" columns in some table, you would have to choose from the screen that had the default "Copy table(s) and view(s)" and choose the other option which is "Use a query to specify the data to transfer" and you would have to build your export query that way.

You also have the option to export all/most of the database objects from A_server to B_server.

Hope this helps!

Thanks

J. Kusch

 

[MARELUAD]

Thanks for your anwser.