if you do not want to programm in DTS ,then you can use enterprise manager of sql server with the following steps :
1-you should register your remote server in enterprise manager
2-you should register local server and attach the local database in the local server
3-if you have not any database on your remote server.you or your host administrator must create a database for your use.also you must have a user for accessing this database.
4-right click on your local database and click 'Export Data' in 'All Tasks' sub menu .then carry on with the wizard.
5-when wizard asks you the destinition database,introduce your database in your remote server.
6-in this method you replicate your database completly to your remote database server.i think you will not have such a problem for constraints.because you have a copy of data and metadata on your remote server.
The wizard is same as DTS import/export data that I tried already.
If you can remember these steps:
1.Select Local host database.
2. Select remote host
database (alread created on the hosting packaged)
On this prompt you will ask to select on of the option.
with 1st option constraints are not copying.(there might be other stuffs also that not appliying to the remote server after exporting)
Once I tried the last option, it will display this.
I tried with deselecting the
Options >>>
Security option and didnt change the
table options, but its giving the same error.
thanks!