Web Site's database data synchronize

[infrared]

hi people.
i'm using SQL Server 2000.
i'm building a web site to some kind of organization.
i need from time to time to update the data on the site with the data from my laptop. (the site is still in the building process, and the organization manager want to see the advancement).
i already updated the *.asp files, but the SQL server is different.
because the web site is been hosted in host company server, they have their own rules. as the database creator, i only get the permission public and not db_owner. that means, when i want to use the "Import and Export Data" to copy objects (such as procedures or even table as is), i can't. it says that i don't have the permission to alter database, but i can do it (all the updating) by the SQL Query Analyzer. i deleted all the tables manually, then created all of them again, using the option to create "Generate SQL Script" in the SQL Server Enterprise Manager, and then i copy all the data table by table (by it's level of dependency to each other) until i finish this, i see stars flying in above my head :sick: , and the phone don't stop to ring, the manager is on-line, wants to see results...

i'm sure there is another way to accomplish this mission...
please... help!

[Krzemo]

because the web site is been hosted in host company server, they have their own rules. U have to create changes script and send it to database adminitrator for execution. U shouldn't try to do it by youself. When U do this not logged as "sa" user than all objects created by U have to be accessed (by other user) using your user prefix - and it could change database logic.
When U push out your script to DB admin than it can make your live easier (no phones to U - all to DB admin :D )

U could also send them copy of your database files to attach in place of original one or as new database (and than send them DTS package too)

Best regards,
Krzemo.