Hi,
I have a MS SQL database on a shared host, and would like to move it to a new shared server host.
When moving, the database should remain exactly the same, without re-indexing of primary keys etc.
The trouble is, my new host will not attach a SQL Server database, and are unwilling to restore from a back-up (it's no problem getting the detached database or backup file from the current host, the problem is applying them to the new host).
Question is then, is it possible to achieve this through some kind of data export/import?
Thanks for any help guys...
I have a MS SQL database on a shared host, and would like to move it to a new shared server host.
When moving, the database should remain exactly the same, without re-indexing of primary keys etc.
The trouble is, my new host will not attach a SQL Server database, and are unwilling to restore from a back-up (it's no problem getting the detached database or backup file from the current host, the problem is applying them to the new host).
Question is then, is it possible to achieve this through some kind of data export/import?
Thanks for any help guys...