If I create a database in SQL Express and then copy the MDF/LDF files and attach them to a machine running SQL Server 2005 Standard - will this new database have SQL Express limitations?
Are there good reasons not to do this and create the database in SQL Server Standard using scripts generated from the SQL Express instance instead?
Basically, I'm setting up a merge replication between Standard and SQL Express for a common database and I figure attaching a copy of the database created in SQL Express is the fastest way to get this started.
Moving this thread over to the Express forum. They may be able to help with the limitations question.
Thanks,
Sam
You can attach the file created on SQL Express to SQL Standard Edition, they are the same product and use the same file format. The limitation are specific to SQL Express, not the database file itself. In comparing copying the file and running a scirpt, I'm not aware of any particular benefits or limitations of one over the other.
From the stand point of Replication, there is no particular reason you need to do it this way. I'm guessing that you are developing locally using SQL Express and then moving your database to SQL Standard to setup your Publication. To my knowledge (I'm not a repl expert) you don't actually need to have a copy of the database on SQL Express in order to create a Subscription once you set up your Publisher on Standard. I believe you can configure things so that a database is created at the Subscriber when you initialize a new Subscription. That's obviously a question for the Repl forum if you run into issues there.
Mike
No comments:
Post a Comment