April 19, 2005 at 7:43 am
Hi,
When I do data import using Enterprise manager and choose the option "Copy table(s) and View(s) from source database", Am I telling Sql Server to convert the views from the source database to tables in the destination database ?
Thanks
Dinuj
Dinuj Nath
April 19, 2005 at 8:00 am
No. Using this option transfers the object(s) between server(s) or database(s). SQL does NOT convert from 1 object type to the other.
Good Hunting!
AJ Ahrens
webmaster@kritter.net
April 20, 2005 at 1:21 am
April 20, 2005 at 1:24 am
Thanks AJ,
But this is exactly what happened. The view returns about 8000000 records and while importing with the options described in my post the view got converted to table.
I don't know what's happening. I am not a DBA and I have limited knowledge of admin.
Dinuj Nath
April 20, 2005 at 1:32 am
April 20, 2005 at 4:42 am
Thank you all
Dinuj Nath
April 21, 2005 at 7:14 am
This is the reason I start my day with sqlservercentral.com even before my ritualistic cup of tea...
I haven't had occasion to use import (for views)...so this is definitely a noteworthy point to keep in mind if I ever do need to use it...
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy