Hello,
I have created a database on my home development server (Microsoft SQL Server 2005 Express). Now I finally found a hoster that fits my needs and I would like to migrate my database to this hosted SQL Server.
The database contains:
- Tables
- Data inside tables
- Views
- Stored procedures
I can connect to this server remotely. However I don't have file access so I can't just restore backup (forcing the recreation of the structure). I thought about using the script export function, but this doesn't include the data that is in my tables.
What is the most efficient way to migrate my database?
I have created a database on my home development server (Microsoft SQL Server 2005 Express). Now I finally found a hoster that fits my needs and I would like to migrate my database to this hosted SQL Server.
The database contains:
- Tables
- Data inside tables
- Views
- Stored procedures
I can connect to this server remotely. However I don't have file access so I can't just restore backup (forcing the recreation of the structure). I thought about using the script export function, but this doesn't include the data that is in my tables.
What is the most efficient way to migrate my database?
Comment