Advise on SQL Server synchronization ...

S

smatanza

Perch
Hey guys,
Anyone may help me with any advise about what is the best method to synchronize (or transfer) all objects (tables and views) from my local SQL Database to the located in the Jodohost Server ?. I?m trying with DTS and SQL Scripts with all the possible options with to much errors.
Thanks for your help !!!
;)
 
Yes, in fact that is the first option that i?ve tried but with that, the views are converted to tables. There's any way to export the views AS VIEWS with the export option ?
Thanks a LOT !!
 
?? I do this all the time -- Views are transferred as Views... exactly how are you exporting the database?
-Dave
 
I'm just guessing here, but perhaps you're not selecting the correct option in the Export Wizard. There's a screen called "Specifiy Table Copy or Query". If you select the default, "Copy table(s) and view(s) from the source database", I believe views are copied as tables. You should be able to have the views copied as views if you select "Copy objects and data between SQL Server databases".

Good luck!
 
You must log in or register to reply here.
Back
Top