First log on to the remote database server:
1. Right-click the database you are preparing to import data from, select Import data under All Tasks
2. Go to the DTS Import/Export Wizard and click the Next button to continue
3. Select the data source, enter the database server name, user name, password, and the source database where you want to copy the data source, and click the Next button
4. For the purpose, enter the database server name, username, password, and destination database for which you want to copy the destination database, and click the Next button
5. Select Copy mode, generally choose "Copy tables and views from source database", click "Next" to continue
6. Select the tables and views that you want to copy, and click Next to continue
7. Set the scheduling mode, the general election "
run immediately " can, and then click "Next" to continue
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.