Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy a table from one SQL server to another?
Message
 
 
To
17/06/2015 16:16:57
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01621098
Message ID:
01621107
Views:
42
>>The number of records is not that great (probably less than 1000). I didn't realize that you can script the table with the values (I thought script is for creating the structure of a table). Do you remember/have an example of a syntax of such script?
>
>Yes, ok, this is based on my framework. However, if you wish to have the method, it can guide you on the core of the operation. You would just need to adjust to fit the fact that the data dictionary data does not come from a table but on hardcoded information you would use instead. Let me know if you want it.

Thank you. I think what Borislav suggested should work. I will test it first on my databases.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform