|
Subject:
|
SQL Script to populate TBH database
|
|
Posted By:
|
motemape
|
Post Date:
|
5/21/2007 10:03:48 AM
|
Hi,
Did someone please know where to get all the sql script files(Insert, Update,...) that polulate the whole database?
Or better how to generate those file from Visual studio.Net?
I only manage to generate the sql files for creating empty tables.
Many thanks 
PS: Do you know another software manager that can perfom the database import task other than SQL Server Microsoft Studio Express? I later install the MSSQL Standard Edition on top on Express, but I couldn't manage to activate the SSIS.
|
|
Reply By:
|
englere
|
Reply Date:
|
5/23/2007 10:10:40 PM
|
This is a timely question because I have been working with the new SQL Server Database Publication Wizard, and this is exactly what you're looking for. But Marco provided us with a full database in the code download, and that is easy to use. You can also copy the .dbf to another server and attach it there.
But you can't easily populate a remote server in a shared hosting arrangement where you don't control the server. In this case, you have the DBO role in your own database, but you are NOT in the SA group. See my other message here about how to deploy to those servers - the subject of my message will be: "Database Deployment to Shared Servers; SQL Script". That can make you a complete SQL script. At least I think it's complete.
Eric
|
|
Reply By:
|
motemape
|
Reply Date:
|
5/25/2007 4:42:00 AM
|
Thank you very much,
I also believe that the new SQL Server 2005 Database Publishing Wizard can do the job. I will try it soon
Cheers
|
