SQLTeam.com | Weblogs | Forums

Importing Data from local database to host server database

sql2014

#1

The current user is not an owner of the selected database. This might cause some operations with this database to fail. this error occurs when I use import and export wizard to import data from local database to host server database....Please help.

All the best, Ronald


#2

The user should have database permission to insert data in that table. Please check the permission and revert if any issues


#3

Thanks @Viggneshwar it a great help, however I managed to upload using import and export wizard somehow it appears that I used wrong provider when configuring destination and source providers. prior to your suggestion, I was given rights as a user for that database on my host control panel when I added myself on it. but I am helped thanks. Ronald @whimbrel Software....SA