July 23, 2003 at 4:24 pm
I aim is to transfer, objects & data from one sql server to another server. I created the tables thru scripts. I tried the wizard to transfer data. Now, it copied all data to tabless, but also created the views as tables. (???)
Then I deleted all tables, and tried the DTS designer and used the 'Copy SQL server objects Task'. Here I choose,
1.Create destination objects (......)
2. drop destination objects first
3. include all dependent objects
4.copy data
5.replace existing data.
Now, tables & stored procedures are ccreated. No data is copied and no views were created. (no clue ...???)
There was an error saying a role was not existing... and I pressed ok. Does it mean that this task stopped in the middle ?
July 24, 2003 at 2:00 pm
You might have selected the first option in the DTS package in “Specify table COPY or Query” option. Select “Copy objects and Data between SQL Server Databases” and depending on your requirement choose the Drop and recreate object and extra stuff. Now uncheck the COPY all object and go to the Select objects menu and choose from the list of available options
Shas3
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply