User Instance Headache : SQL Server 2005 Express
-
Hi, After I finished my Win Application (with SQL Server 2005), I wanted to ship my application with the .mdf database file. But the version of the software I am using in my PC, I have my personal data in the .mdf. I want to ship the empty .mdf file but At the same time I dont want to delete those data in my version of the .mdf which is installed in my PC. I am really having difficulties with that. Because, All instanced of the .mdf file is being synchornized everytime. So Do I need to take a copy of this .mdf file to another computer and delete all data and then make the installer to ship ? Inst there any other easy way to do that ? Thanks Emran
-
Hi, After I finished my Win Application (with SQL Server 2005), I wanted to ship my application with the .mdf database file. But the version of the software I am using in my PC, I have my personal data in the .mdf. I want to ship the empty .mdf file but At the same time I dont want to delete those data in my version of the .mdf which is installed in my PC. I am really having difficulties with that. Because, All instanced of the .mdf file is being synchornized everytime. So Do I need to take a copy of this .mdf file to another computer and delete all data and then make the installer to ship ? Inst there any other easy way to do that ? Thanks Emran
i only have sql server 2000, so i dont know if this reply will completely answer your question. try creating a new database then importing the data into it. if that doesnt work, then try copying your .mdf and .mdl to a different name, then attaching them in sql server as a different database name. if neither of those work, then i would wait for someone else who might have a better idea or (perhaps quicker) would be what you suggested.