I locally created a database in SQL Server 2012, there was a table, now I want to move the data in the database to another computer, on the other individuals in the database, so how to operate?
I just found the database file

And you could use this file to send chat mode, appear this kind of tip

I don't know what I should terminate programs, how can I send oh
Hope leaders can answer questions dishes of chicken, thank you thank you!!!!!!!!!!

CodePudding user response:

The sqlsever service to stop

CodePudding user response:

If only the data of a table, can directly use SQL statements to table writes the new database can
Is the old server database, for example: A, B is the new server database
In database B: SELECT * INTO table name from 172.16.. Trying. Dbo. Table name

CodePudding user response:

Depends on what your needs, in the new server if the original server database separation, copied to the new server up additional,

To real-time query can do link to server

To analyze the data or can do on the test database backup, the backup data recovery to the new server

CodePudding user response:

Or stop the service, or separate databases, or backup and restore, will do,

CodePudding user response:

1. After the separation, copy the file to other computers, additional again can
2. After the backup recovery in other computers