Tuesday, February 15, 2011

MS SQL / Visual Studio - EXPORT TABLE or VIEW with records into sql statement

In Visual Studio go to view/Server explorer.
Right click on database (you may need to create new connection if required) and select publish to provider.
Click next and select RJM BackOffice, uncheck script all objects.
Click Views then next
Select View then next
Script to file then next
Script for target database - you may need to select 2000
Next and finish.

No comments:

Post a Comment