All posts
Databases & SQL

Copy a database table from one server to another    

To copy a database table from one server to another server. Export the data to an excel file. Create the new table on the new  server. If there is an autonumber unique key, this field needs to be set to not an identifier while the data is imported. Import the data, then reset the  autonumber key.