Hello,
I am a candidate for web programming..I would like to desing a website and I have a good host which is supporting .net 2.0 and sql server 2005 service. So I would like to ask you
1) how can I use sql server express edition's mdf database file there. or Can I store and use this "mdf"s in ftp folder? What should I do. ..
2) I have only one database "right" there and should I manage everything in one database. For example asp.net configuration manager created ASPNETDB.mdf and ldf...so if Can you inform me about this issue?
Maybe my questions is not advance, they are very basic but I want to learn
Thank you very much for your helps.
Hi,
From your description, it seems that you want to deploy the database in your SQLExpress to the SQLServer2005 database on your host server, right?
If so, I suggest that you should use some tools to achieve that instead of attaching MDF manually. First, you may use aspnet_regsql.exe tool convert the database in SQLExpress to your local SQLServer series database. In you case it's SQLServer2005. After that, use SQLServer export and import wizard to upload the database (including table and schema) to the SQLServer2005 instance on your server.
For aspnet_regsql.exe, see:
http://msdn2.microsoft.com/en-us/library/ms229862.aspx
Thanks.
No comments:
Post a Comment