One option is that you could create your own "template"
database in SQL Server, then detach the database. You can
save the mdf and ldf files and then just use these and copy
them to whatever workstation and attach the files as needed.
You can find more information on sp_detach_db and
sp_attach_db in books online.
-Sue
On Wed, 15 Aug 2007 14:20:08 -0400, "Scott M."
[quoted text, click to view] <s-mar@nospam.nospam> wrote:
>Hello,
>
>I need to be able to get a database with populated tables created
>on-the-fly. This is for a classroom environment where each student works
>with his/her own SQL or SQL Express database on their local machine. I need
>to find a quick way to take my data (currently in Access 2003) and get a
>comprable SQL 2005 or SQL Express database with populated tables set up.
>
>Thanks,
>
>Scott M.
>
More currently, CREATE DATABASE FOR ATTACH
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:1657c3hn91r3j9cvk74h7jj94midlie56k@4ax.com...
> One option is that you could create your own "template"
> database in SQL Server, then detach the database. You can
> save the mdf and ldf files and then just use these and copy
> them to whatever workstation and attach the files as needed.
> You can find more information on sp_detach_db and
> sp_attach_db in books online.
>
> -Sue
>
> On Wed, 15 Aug 2007 14:20:08 -0400, "Scott M."
> <s-mar@nospam.nospam> wrote:
>
>>Hello,
>>
>>I need to be able to get a database with populated tables created
>>on-the-fly. This is for a classroom environment where each student works
>>with his/her own SQL or SQL Express database on their local machine. I
>>need
>>to find a quick way to take my data (currently in Access 2003) and get a
>>comprable SQL 2005 or SQL Express database with populated tables set up.
>>
>>Thanks,
>>
>>Scott M.
>>
>
Thanks Sue & Rick. This sounds like what I'm looking for. I'll give it a
shot.
-Scott
[quoted text, click to view] "Rick Byham, (MSFT)" <rickbyh@REDMOND.CORP.MICROSOFT.COM> wrote in message
news:48B84FBB-71A4-4D1A-A869-27C63C2322A7@microsoft.com...
> More currently, CREATE DATABASE FOR ATTACH
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> news:1657c3hn91r3j9cvk74h7jj94midlie56k@4ax.com...
>> One option is that you could create your own "template"
>> database in SQL Server, then detach the database. You can
>> save the mdf and ldf files and then just use these and copy
>> them to whatever workstation and attach the files as needed.
>> You can find more information on sp_detach_db and
>> sp_attach_db in books online.
>>
>> -Sue
>>
>> On Wed, 15 Aug 2007 14:20:08 -0400, "Scott M."
>> <s-mar@nospam.nospam> wrote:
>>
>>>Hello,
>>>
>>>I need to be able to get a database with populated tables created
>>>on-the-fly. This is for a classroom environment where each student works
>>>with his/her own SQL or SQL Express database on their local machine. I
>>>need
>>>to find a quick way to take my data (currently in Access 2003) and get a
>>>comprable SQL 2005 or SQL Express database with populated tables set up.
>>>
>>>Thanks,
>>>
>>>Scott M.
>>>
>>
>
Don't see what you're looking for? Try a search.
