J
Jonathan Wood
On my development machine, I've been creating databases as standalone
database files rather than creating them under SQL Server Express, and then
specifying AttachDbFilename in the connection string for testing.
This has worked well: My SQL Server Express is not cluttered with test
databases, and I haven't had to deal with all the connection errors that no
one could explain when I try to access a SQL Server Express database.
But now I need to transfer my database to the server that is hosting my
Website.
I was looking into the tools at www.simego.com (for importing data into a
database, and for synchronizing databases between desktop and server). This
tools only appear to work with databases that are actually attached to the
server. So I have the following questions:
1. If I attach a database to the server (however that is done), can I do it
temporarily and then detach it after I'm finished?
2. If so, how would I temporarily attach it, and how would I then detach it?
3. I also have access to SQL Server 2005 and the Management Studio that I
understand comes with it. Does anyone have any opinions as to whether I'm
better off with the simego.com tools or SQL Server 2005 (keeping in mind
that I'm trying to keep this as simple and painless as possible)?
Thanks!
database files rather than creating them under SQL Server Express, and then
specifying AttachDbFilename in the connection string for testing.
This has worked well: My SQL Server Express is not cluttered with test
databases, and I haven't had to deal with all the connection errors that no
one could explain when I try to access a SQL Server Express database.
But now I need to transfer my database to the server that is hosting my
Website.
I was looking into the tools at www.simego.com (for importing data into a
database, and for synchronizing databases between desktop and server). This
tools only appear to work with databases that are actually attached to the
server. So I have the following questions:
1. If I attach a database to the server (however that is done), can I do it
temporarily and then detach it after I'm finished?
2. If so, how would I temporarily attach it, and how would I then detach it?
3. I also have access to SQL Server 2005 and the Management Studio that I
understand comes with it. Does anyone have any opinions as to whether I'm
better off with the simego.com tools or SQL Server 2005 (keeping in mind
that I'm trying to keep this as simple and painless as possible)?
Thanks!